January 7, 2012 at 4:32 am
Adding few thoughts here:
•Time Dimension is the most difficult dimension (IMO) to populate. Many guys (here) may oppose to me but I have seen long (& boring / interesting sometimes) discussions to populate week table in time dimensions. I can give you few crazy business questions / scenarios.
oA week may overlap two months? Where to count it?
oA week may overlap two years as well.
oDoes the week means strictly 7 days?
oMany industries have their own week definitions like Retail.
oA week may start on Monday / Sunday.
•Time zones are also crazy items to handle especially with Day Light Saving.
Thus before jumping on table design, evaluate business requirements thoroughly. Creating a script for a table will not take more than 5 minutes, if you have reasonable good with DDL statements.
Viewing post 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply