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.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *