Why should surrogate keys be used rather than natural keys in a dimensional model?
- A They remain stable when source systems change and support Type 2 history
- B They are shorter to type
- C They are required by SQL
- D They improve encryption
Answer
They remain stable when source systems change and support Type 2 history
With Type 2 dimensions the natural key repeats across versions, so only a surrogate key can uniquely identify a specific version.





