Question
Why should a warehouse maintain an “Unknown” dimension member?
Select an option. Your answer will be checked instantly.
Correct Answer: D. To preserve referential integrity when a source key is missing or unmatched
Explanation:
Unknown members provide a valid key when business context cannot be resolved.
They keep facts loadable while making data-quality issues visible.
Leave a Reply