Explain difference between view and materialized view?
No Answer is Posted For this Question
Be the First to Post Answer
Can we have more than one time dimensions in a Schema(Star or Snowflake)
What is loop in data warehousing?
explain about dirty dimension?
Explain what is the difference between power center & power mart?
Explain what are the modules in power mart?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Explain dimensional modelling?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
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?
Explain about core dimension,
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What Oracle tools can be used to design and build a W/H?