| Fact Table [message #610618] |
Fri, 21 March 2014 17:27 |
nagaraju.ch
Messages: 103
Registered: July 2007
Location: bangalore
|
Senior Member |
|
|
Hi there,
I am designing datawarehouse data model and have Subscriptions fact table. I am confused whether to build two tables one for Subscriptions another for Unsubscriptions, Or Multiple rows in single table for each Subscription and Unsubscriptions Or One Row with Update when Unsubscription happen(there may be performance issue on this as huge data will be in the fact table)
Please advise which way would be better, My requirement to build the Subscriptions and Unsubscriptions measures in my reporting.
Source have one table which includes each and every event(subscription, Unsubscripition, Subscription.....etc.)
Thanks in advance
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
