Tobias Brox wrote:
I suppose the strongest argument for introducing date dimensions already now is that I probably will benefit from having conform and well-designed dimensions when I will be introducing more data marts. As for now I have only one fact table and some few dimensions in the system.
Another factors to consider is that end user tools (and end users) may find a date/time dimension helpful.
Best wishes Mark