Lesson 4 of 6 in this module

25/33 in track

Slowly Changing Dimensions Type 1 / 2 / 3

sql16 min

Locked lessonWarehouse & Dimensional Modeling

Slowly Changing Dimensions Type 1 / 2 / 3

SCD Type 1 overwrites. Type 2 versions rows. Type 3 keeps one previous value on the same row.