Have you ever wondered which is the right name to name a dimension related to time and dates?
Well, there is not aright way to name it but if you follow the Business Intelligence Standards and some bibliography then the name should be "Dim Date".
The explanation is because most of the transactional systems work with dates and not with times, the goal is to have a continuous line of time, day after day. Hence our Dim Date will contain one row per day of the year. In other words, our table will have 365 rows per each year.
How many years should I populate in my Dim Date?
It depends on your business, if the transactional system has information since let say 10 years ago, your Dim Date have to start at least since the first date recorded in your transactional system. And what about the future? This will also depend on your business if you have sales projections, estimates or some data that is future.
One easy answer is to have around 100 years of dates in the Dim Date.