Home » Developer & Programmer » Designer » Fact Table (Oracle 11G, Unix)
Fact Table [message #610618] Fri, 21 March 2014 17:27
nagaraju.ch
Messages: 98
Registered: July 2007
Location: bangalore
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
Previous Topic: Data Modelling
Next Topic: Designer Date and Time
Goto Forum:
  


Current Time: Fri Nov 21 21:25:12 CST 2014

Total time taken to generate the page: 0.11143 seconds