mediumde-scd

Slowly Changing Dimensions (SCD): what are Type 1 and Type 2 and when do you use them?

Answer

SCDs handle dimension changes over time. - Type 1: overwrite history (keep latest) - Type 2: preserve history with version rows (effective dates) Type 2 is used when historical accuracy matters (e.g., customer segment at purchase time). Type 1 is simpler when history is not needed.

Related Topics

Data ModelingWarehousingSCD

Related Questions

ETL vs ELT: what’s the difference and when do you choose each?

Data warehouse vs data lake: what are the differences and use cases?

What is a lakehouse and what problems does it solve?

Back to Data Engineer All Professions