Question

Surrogate keys are used in data warehouses because:

A They are always smaller than natural keys
B They provide stable, system-generated identifiers independent of source system keys
C They guarantee uniqueness across schemas
D They automatically enforce constraints
E They prevent data skew
Practice Next

Hey! Ask a query