Which SCD type creates a new record with a new surrogate key for any change in a dimension attribute, thereby keeping all historical data?
- SCD Type 0
- SCD Type 1
- SCD Type 2
- SCD Type 3
SCD Type 3 (Slowly Changing Dimension Type 3) creates a new record with a new surrogate key for any change in a dimension attribute, preserving all historical data. This type maintains a history of changes while not retaining multiple records for the same entity.
Loading...
Related Quiz
- How does a "risk matrix" aid in the IT risk management process?
- A _______ provides a consolidated and consistent view of data sourced from various systems across an organization.
- Which method involves the use of algorithms and statistical procedures to discover patterns in large datasets?
- An organization wants to update its data warehouse with daily sales data. The sales data is vast, but only a small portion changes daily. Which data load approach would be most efficient?
- For an organization that requires immediate insight into business operations, which type of BI would be most appropriate?