Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Always link date fields to Date Dimension?

2 posters

Go down

Always link date fields to Date Dimension? Empty Always link date fields to Date Dimension?

Post  boernard 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

Back to top Go down

Always link date fields to Date Dimension? Empty Re: Always link date fields to Date Dimension?

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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