Question
A sales fact may have no promotion associated with it. What is the preferred dimensional handling?
Select an option. Your answer will be checked instantly.
Correct Answer: B. Use a designated “No Promotion” or unknown dimension member
Explanation:
Fact foreign keys should remain valid and referentially consistent.
A special dimension member represents the legitimate absence of a promotion.
Leave a Reply