Lesson 3 of 6 in this module

24/33 in track

Surrogate keys & conformed dimensions

sql12 min

Locked lessonWarehouse & Dimensional Modeling

Surrogate keys & conformed dimensions

Natural keys come from source systems. Surrogate keys are warehouse-owned integers shared across facts.