SCD Type 3

Slowly Changing Dimension Type 3 ( SCD Type 3) tracks the history my adding separate columns for each version of record. As opposed to Slowly Changing Dimension Type 2 ( SCD Type 2) where we can maintain any number of history of record SCD Type 3 allows limited history of record as adding a separate column for each version is not a good practice. Generally it allows to maintain history up to 2 level.

e.g.

After looking at above example it’s clear that with SCD Type 3 we can not track the history of Company movement if it moves again to new Location.

Did you enjoy this article? Please subscribe to Email or RSS to receive all the FREE updates!

Related posts:

1. SCD Type 1
2. SCD Type 2
3. Slowly Changing Dimension

Tagged as: Data Warehousing Concepts, SCD Type 3, Slowly Changing Dimension Type 3