🗄️Slowly Changing Dimension (SCD)
Also known as SCD, SCD Type 2, Type 2 Dimension
A dimension whose details change over time. Type 2 keeps a row per version.
Think of it like
It is like a height chart on a door. You add a new mark each year and keep the old ones.
Example
Lucy moves from Leeds to London in May. With Type 2, her March orders still count for Leeds, and her June orders count for London.
Why it matters
Without it, old reports change when someone moves. Last year's sales by city would quietly shift.
Definition
Common mistake
Key takeaways
- 1Type 1. Overwrite and lose the old value.
- 2Type 2. Add a new row with dates.
- 3Keeps history. Old facts keep old details.