Question
What is a natural key in dimensional modeling?
Select an option. Your answer will be checked instantly.
Correct Answer: D. A business identifier supplied by a source system, such as CustomerCode
Explanation:
Natural keys identify entities in operational business contexts.
The warehouse typically uses them during lookup while storing surrogate keys in facts.
Leave a Reply