After we create a scd table, can we use that particular dimension as a dimension table for star schema?
No Answer is Posted For this Question
Be the First to Post Answer
What is surrogate key? Where we use it? Explain with examples.
Explain can report net connect multiple datasource at a time in report creation time?
Explain how are the dimension tables designed?
What are the key columns in Fact and dimension tables?
What is the use of incremental aggregation? Explain me in brief with an example?
What are components of report studio?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Explain the different types of data warehousing?
What is hash partition?
What are snapshots? What are materialized views & where do we use them?
What are situations where snowflake schema is better than star schema when the opposite is true?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?