Explain the importance of data warehouse?
No Answer is Posted For this Question
Be the First to Post Answer
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain what are the various transformation available?
What is metadata in context of a datawarehouse and how it is important?
Explain what are the modules in power mart?
What is the difference between power center & power mart?
What is the difference between star and snowflake schemas?
What is Time Series algorithm in data mining?
How can you define a transformation? What are different types of transformations in Informatica?
What is difference between Mapplet and reusable transformation?
What is the main difference between schema in rdbms and schemas in datawarehouse?
What is a core dimension?