Question
Why is a Date dimension usually preferred over storing only a raw date in the fact table?
Select an option. Your answer will be checked instantly.
Correct Answer: B. It supplies reusable calendar, fiscal, holiday, and period attributes
Explanation:
A Date dimension gives users rich, standardized time attributes.
It supports fiscal calendars, weekdays, holidays, and hierarchies without repeated logic.
Leave a Reply