Explain what are the different types of data warehousing?
What is subject area?
Explain why denormalization is promoted in universe designing?
What are the stages that are required in data warehousing?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
Where the cache files stored?
Explain hybrid slowly changing dimension?
Explain the main differences between star and snowflake schema?
Can any one explain the hierarchies level data warehousing.
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
what is indexing ? what are different types of indexes supported by oracle ?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Describe the differences between a data warehouse and data mart.