Data → Data Platforms
SCD
A dimensional-modeling technique for representing how descriptive attributes change over time.
SCD
A dimensional-modeling technique for representing how descriptive attributes change over time.
Common types
- SCD Type 1 overwrites old values and keeps only the current state.
- SCD Type 2 creates versioned rows so full history is preserved.
- SCD Type 3 stores limited previous-state columns beside the current value.