Question 5 of 10Pro Only
What is a date dimension table, and why is it so important in data warehouse design? What columns should it include?
Sample answer preview
A date dimension table is a pre-populated reference table containing one row for every date across your analytical time range, enriched with attributes that enable time-based analysis.
date dimensionfiscal calendarrelative date flagsbusiness dayholidayISO week