Question
What is the purpose of a dimension lookup during fact loading?
Select an option. Your answer will be checked instantly.
Correct Answer: B. Find the warehouse surrogate key corresponding to a source natural key
Explanation:
Facts store surrogate dimension keys rather than source identifiers.
The lookup resolves the correct dimension member, including its historical version when required.
Leave a Reply