The ________ slowly changing dimension approach creates a new additional dimension record using a new value for the surrogate key every time a value in a dimension record changes.
A)Type 1
B)Type 2
C)Type 3
D)Type 0

Question

Quizplus · Accepted Answer

The Type 2 slowly changing dimension approach tracks changes to dimension records over time by creating a new additional dimension record with a new value for the surrogate key every time a value in a dimension record changes. This approach preserves historical data and enables analysis of data at different points in time. Types 1 and 3 also handle changes to dimension records, but do not create new records and do not preserve historical data to the same extent as Type 2. Type 0 is not a recognized approach for handling changes to dimension records.

The ________ Slowly Changing Dimension Approach Creates a New Additional