"A dimension table is wide but the fact table is deep," explain the statement in your own words.
1387What is junk dimension? What is the difference between junk dimension and degenerated dimension?
1061What 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?
1071Post New Data Warehouse General Questions
What is defined as partial backup?
What are the different models used in cluster analysis?
Explain how to get the first 100 rows from the flat file into the target?
What are the differences between datamart vs. Reporting cube?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What are data validation strategies for data mart validation after loading process?
Can you state some of the innovations throughout history?
How do you define data block size?
explain about dirty dimension?
What are the various tools? Explain name a few?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is an error log table in informatica occurs and how to maintain it in mapping?
How do you create surrogate key using ab initio?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
Explain hybrid slowly changing dimension?