Always link date fields to Date Dimension?

View previous topic View next topic Go down

Always link date fields to Date Dimension?

Post  boernard on Wed Mar 28, 2012 12:16 pm

Hi,
yet another question:
It is clear, that a date dimension connected to a fact table totally makes sense.
But how about when you have date information in other dimensions? Would you all link them to (views of) the date dimension? Or would you only link them to the date dimension if analysis based on the data in the date dimension (weekday, calendar week, ...) is necessary?

boernard

Posts : 13
Join date : 2012-01-19

View user profile

Back to top Go down

Re: Always link date fields to Date Dimension?

Post  ngalemmo on Wed Mar 28, 2012 1:48 pm

Generally, no. Dates that are just dates (effective/expiration dates, for example) should be stored as dates. If the date has such meaning that date dimension attributes are required, it is questionable wither the date should be embedded in a dimension or placed as an FK in the fact.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum