Data modelling · Advanced · 4 h

Slowly changing dimensions

Keep history when customers move, prices change and products are renamed.

Why employers care: Historical accuracy is a core warehouse responsibility. SCD type 2 is a standard data engineering interview topic.

In the roadmaps for: Data Engineer