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

accumulating fact question

3 posters

Go down

accumulating fact question Empty accumulating fact question

Post  topcat Thu Mar 21, 2013 5:28 pm

i have an accumulating fact table that basically is a subscription fact. it joins people to groups. people subscribe and unsubscribe to a group. my fact table has a subscribe date key and an unsubscribe date key, both FKs to our date dimension. when the person is subscribed and not unsubscribed, what should i set the unsubscribe date key to? do i need to create a record with a high value for the date? like year 9999?

i dont want to make the unsubscribe date key NULLable.

thanks

topcat

Posts : 19
Join date : 2012-08-09

Back to top Go down

accumulating fact question Empty Re: accumulating fact question

Post  ngalemmo Thu Mar 21, 2013 6:11 pm

If the subscription has an expiration date, you may want to use that. Otherwise reference a high date such as 12/31/9999. Discuss it with the business.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

accumulating fact question Empty Re: accumulating fact question

Post  BoxesAndLines Thu Mar 21, 2013 10:59 pm

Use the same value as all of your other dimensions that are not applicable.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

accumulating fact question Empty Re: accumulating fact question

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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