Just Learned: Date Dimensions #DWH

Berthold just told me that it is of advantage to have a date dimension per date attribute in the fact table. At first I didn’t like the idea, but he is right:

Having one date dimension table for each date attribute in the fact table has the advantage that when end-users want to select a specific date from a drop-down box, they only see those date where the attribute has data for.
Continue reading