The short answer
Slowly Changing Dimensions (SCD) describe how dimension attributes change over time.
SCD1: overwrite the old value. No history.
customer_id=7 city: Austin -> Dallas
table now shows Dallas onlySCD2: keep history with new rows (and usually valid-from / valid-to or is_current).
customer_id=7
row1: Austin valid 2024-01-01 to 2026-03-01 is_current=false
row2: Dallas valid 2026-03-01 to null is_current=trueWhen to use which
- SCD1: corrections, unimportant history (fix a typo in name)
- SCD2: analytics must answer "what city were they in when they ordered?"
are a common SCD2 implementation helper.
Interview tip: Give the overwrite vs history contrast, then one business question that only SCD2 can answer.