accumulating fact question
3 posters
Page 1 of 1
accumulating fact question
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
i dont want to make the unsubscribe date key NULLable.
thanks
topcat- Posts : 19
Join date : 2012-08-09
Re: accumulating fact question
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.
Re: accumulating fact question
Use the same value as all of your other dimensions that are not applicable.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Accumulating Snapshot and Transaction Fact tables : question to design and use them together
» Tracking Support Tickets: accumulating snapshot and transaction grain fact (a presentation question)
» Modeling Question - Accumulating Snapshot vs. Event Transactions
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
» How to represent survival rates in a fact table?
» Tracking Support Tickets: accumulating snapshot and transaction grain fact (a presentation question)
» Modeling Question - Accumulating Snapshot vs. Event Transactions
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
» How to represent survival rates in a fact table?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum