Is Holidays a dimension?
3 posters
Page 1 of 1
Is Holidays a dimension?
On the one hand, I can put US_Holiday_Flag, CA_Holiday_Flag, MX_Holiday_Flag, etc. into the Date dimension. On the other hand, I may not know 10 years into the future what all the holidays might be in all the countries I need to support. I've seen ready-made table scripts with the former. Is there standard school on this? Or, at least, a healthy debate?
Is Holidays a dimension?
Yes it is, but it can be a outrigger dim to the date dim since you want to support multiple holidays.
zoom- Posts : 97
Join date : 2010-08-23
Location : Chicago
Re: Is Holidays a dimension?
This can be a real "banana skin" area. Watch out for countries like Australia where each state has it's own public holiday dates and NZ with County holidays.
The other tricky aspect to consider in your design is "who's holiday" e.g. you have a customer in location X serviced by a team in location Y - which public holidays should apply?
Good luck!
The other tricky aspect to consider in your design is "who's holiday" e.g. you have a customer in location X serviced by a team in location Y - which public holidays should apply?
Good luck!
Similar topics
» Happy Holidays
» bridge table and junk dimension on customer dimension (bank/credit union)
» modelling Product dimension for Pizza outlet
» How to handle a Type I or II dimension with a snowflaked customer sub dimension (kimball book page 337, 338)
» Tip #136 Adding a Mini-Dimension to a Bridge Table: What if you can't split the dimension?
» bridge table and junk dimension on customer dimension (bank/credit union)
» modelling Product dimension for Pizza outlet
» How to handle a Type I or II dimension with a snowflaked customer sub dimension (kimball book page 337, 338)
» Tip #136 Adding a Mini-Dimension to a Bridge Table: What if you can't split the dimension?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum