easy5 pts · first answer countsdata-modelingsurrogate-keys

Why use surrogate keys

Why do warehouse dimension tables often use a surrogate key instead of the source system ID?

A.Surrogate keys make queries return more rowsB.Source IDs are not allowed in warehousesC.Surrogate keys encrypt the customer dataD.It lets one source ID have several history rows (SCD Type 2) and protects you from source ID changes or clashes

Discussion 0

Join free to post in the discussion.

Why use surrogate keys

Discussion 0

Related questions