Scenario: A retail company wants to track changes in product prices over time. Which type of Slowly Changing Dimensions (SCD) would you recommend and why?
- Type 1 SCD
- Type 2 SCD
- Type 3 SCD
- Type 4 SCD
For tracking changes in product prices over time, Type 2 Slowly Changing Dimensions (SCD) would be recommended. This type maintains a history of changes by creating new records for each change, preserving the old ones. It allows for accurate tracking of product price changes without altering existing records.
Loading...
Related Quiz
- What are the key considerations when designing a conceptual schema?
- Scenario: A financial institution needs to ensure data consistency across its distributed database partitions. What techniques or mechanisms can be employed to achieve this while maintaining high availability?
- How does aggregation improve query performance in a database?
- Scenario: A healthcare organization needs to track patient demographics, medical procedures, and billing information for reporting purposes. How would you implement Dimensional Modeling in this scenario?
- The process of organizing data into tables in such a way that redundancy is minimized is called _______.