accumulating fact question

View previous topic View next topic Go down

accumulating fact question

Post  topcat on 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

View user profile

Back to top Go down

Re: accumulating fact question

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

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

View user profile http://aginity.com

Back to top Go down

Re: accumulating fact question

Post  BoxesAndLines on Thu Mar 21, 2013 10:59 pm

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

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

View user profile

Back to top Go down

Re: accumulating fact question

Post  Sponsored content


Sponsored content


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