Question
Why are dimensions generally loaded before related facts?
Select an option. Your answer will be checked instantly.
Correct Answer: D. Fact foreign keys must resolve to valid dimension surrogate keys
Explanation:
Fact loading performs lookups against dimension members.
Loading dimensions first maintains referential integrity and historical correctness.
Leave a Reply