Slowly ChangingDimensions (SCD)
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. In which concept are Slowly Changing Dimensions (SCD) used?
2. What are the two types of schema found in a dimensional Data Warehouse or Data Mart?
3. What does a Fact table keep?
4. How is a Fact table mainly loaded?
5. Which of these is an example of a Dimension?
6. How does the frequency of new rows in a Dimension table compare with a Fact table?
7. If a product code changed from 001 to 002, then 003, then 004, what would SCD Type 1 keep?
8. Which SCD type keeps a complete history of every change to a dimension?
9. If a product code changed from 001 to 002, then 003, then 004, what would SCD Type 3 keep?
10. Why is a Dimension such as Products a candidate for Slowly Changing Dimension handling?