"A dimension table is wide but the fact table is deep," explain the statement in your own words.
1306What is junk dimension? What is the difference between junk dimension and degenerated dimension?
1017What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
1015Post New Data Warehouse General Questions
What are snapshots? What are materialized views & where do we use them?
What is recovering sessions?
What are the data types present in bo?
What is a fact, dimension, measure?
How can we do data cleaning?
Whether dimension table can have numeric value?
Where the data cube technology is used?
I have two universes created by two difference database can we join them in designer & report level? How
what are the different views that are considered when building an object-oriented software system?
Explain difference between data ware house & data mart?
What is meta data and system catalog?
What is the difference between drill through and masterdetail reports?
What is load manager?
What is the difference between power center & power mart?
Explain the data type of the surrogate key?