Question
Why are surrogate keys commonly used in warehouse dimensions?
Select an option. Your answer will be checked instantly.
Correct Answer: C. They provide stable warehouse identifiers independent of changing source keys
Explanation:
Surrogate keys insulate the warehouse from source-key reuse and change.
They also support multiple historical versions of the same natural entity.
Leave a Reply