After creating our DimTime table in the 1ages part of this article, we will now make some improvements on our dimension.
From experience, I would recommend using a key PKDate int type in format yyyymmdd.
This type of key will allow you to get better performance.
This coding in the format yyyymmdd should be generalized at all levels of our axis time: year, semester, quarter, month, week ... So I suggest that each level (year, semester, quarter, month, week, day) be composed of three distinct attributes:
- Last name