Home » Developer & Programmer » Designer » Fact Table (Oracle 11G, Unix)
Fact Table [message #610618] Fri, 21 March 2014 17:27
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
Previous Topic: What is your data modeler?
Next Topic: Designer Date and Time
Goto Forum:

Current Time: Fri Mar 01 07:43:45 CST 2024