Using the Date Dimension for Summary Fact Tables or new specialized Month Dimension?
2 posters
Page 1 of 1
Using the Date Dimension for Summary Fact Tables or new specialized Month Dimension?
I would like to create some summary tables that would summarize Monthly data. Should I use my existing Date Dimension and simply link to the first day of the month or should I create a new Month Dimension Table?
I know it would work either way but I'm looking for what is considered best practice, thanks,
-Matt
I know it would work either way but I'm looking for what is considered best practice, thanks,
-Matt
Re: Using the Date Dimension for Summary Fact Tables or new specialized Month Dimension?
Thats fine, pick a row, there is no need to create another table. It would be different if dealing with a very large dimension where you only need a few attributes due to the desired aggregation, in which case a much smaller junk dimension for those attributes would be a better choice.
Re: Using the Date Dimension for Summary Fact Tables or new specialized Month Dimension?
Ok, that makes sense. At first it seemed cleaner to have a month dimension because it would be obvious to anyone using your fact table that the Date keys pointed to the whole month, but since you probably want summaries at a week, a quarter and a year too, it quickly becomes a pain to manage all these separate dimensions and probably just easier to pick something that makes sense in the existing table to maximize re-usability and flexibility.
Similar topics
» Storing Date Keys in dimension tables versus fact tables
» DATE OR DATE KEYS IN FACT TABLES
» Date instead of date key in fact tables
» Question about using date dimension keys in other dimension tables
» Best practice for date attributes of dimension tables
» DATE OR DATE KEYS IN FACT TABLES
» Date instead of date key in fact tables
» Question about using date dimension keys in other dimension tables
» Best practice for date attributes of dimension tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum