Definition
Slowly changed dimension is a dimension which changes over a time .
Mainly there are 3 types
SCD Type 1
To keep the current data.
SCD Type 2 [DATE | FLAG | VERSION]
To keep the historical data.
SCD Type 3
To keep the current and previous data.
|