What is a view as it relates to system modeling?
What are snapshots? What are materialized views & where do we use them?
Explain what are data marts?
What are the various tools? Explain name a few?
Explain what is data validation strategies for data mart validation after loading process?
Why fact table is in a normal form?
Explain the main difference between inmon and kimball philosophies of data warehousing?
How to load the time dimension?
What are the advantages of raid 1, 1/0, and
Where do we use semi and non additive facts?
In microstrategy, how can we direct the sql generated to use a specifc table?
Explain the main differences between star and snowflake schema?
Explain me what are data marts?
Explain what is type 2 version dimension?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?