Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Performance issue for TRansformer
Hi All, I am trying to build a cube for a massive datasource (over 2 million rows)on a Unix box. The cube build takes over 60 hours which is not acceptable. Creating the METADATA step is consuming a lot of time. Looking for ways to cut the cube build time. Any help would be appreciated. Thanks- lrnr
- Thread
- Replies: 3
- Forum: Cognos solutions
-
dimension table
Thanks Anand for your response. But we are not using any ETL tool, it has to be coded thru PL/SQL scripts. All three systems are live and independent, although the VENDOR might be same its attributes(keys and even names) are different in all 3 systems.SO I am looking for a way to align these...- lrnr
- Post #3
- Forum: Data Warehousing/Big Data
-
dimension table
I have to create a single dimension table from three different sources.The master "Vendor" list exists independently in all 3 sources with different key values and attribute set. The Vendor names although similar may not match exactly. What is the most elegant/low maintenance way of...- lrnr
- Thread
- Replies: 5
- Forum: Data Warehousing/Big Data
