Explain hybrid slowly changing dimension?
No Answer is Posted For this Question
Be the First to Post Answer
What is a staging area? Do we need it? What is the purpose of a staging area?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What is a fact table?
How to import vsam files from source to target. Do we need a special plugin?
Explain why denormalization is promoted in universe designing?
How to stop a batch?
Explain what is power center repository?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are the main steps to build the data warehouse?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Can we take backup when the database is opened?
Explain which are the olap tools available that are supported by oracle?