SQL 116 🛢️ Slowly Changing Dimensions (SCD Types 1, 2, 3, and 6)
Dimension data changes slowly and unpredictably. A customer moves to a new city, a product is recategorized, a salesperson transfers to a different region. A data warehouse that overwrites the old value on every change cannot answer the question “what region was this salesperson assigned to when the sale was made?” Slowly Changing Dimensions (SCD)…