Using Time Dimension

Submitted by nvovn on Wed, 03/22/2017 - 15:34

Performance issues regarding date related data are not that uncommon. Consider a date value:

dateToBeConsidered = 28 Feb 2017

Now I am interested in the following questions: Is dateToBeConsidered a german bank holiday, on a weekend, a Sunday?

In all these cases DWH artists have found a solution called time dimension.

Intermezzo: DWH people like to store data in a star shaped manner, where the facts table is the centre of the star and the dimension tables are the beams or satellites of the star.