Can we create Hierarchies in generic datasources?
- 0 Answers
- 2107 Views
- CTS, I also Faced
- E-Mail Answers
Explain the difference between etl tool and olap tools?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Explain the use lookup tables and Aggregate tables?
what is data modeling?
What are the types of Data Warehouse applications?
Difference between flat files and relational sources?
Which type or t/s is used to convert rows into column & column into rows
When do we analyze the tables?
What is data modeling and data mining?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
State the differences between shortcut and reusable transformation
how would u estimate the size of Aggregator transform data and index cache?
Teradata 
