Re: Data Warehouse Design Help
Posted by:
Rick James
Date: November 14, 2013 05:53PM
So, you intend to have a Fact table with
Date
user_id
transaction_id
affiliate_id
and maybe some more fields.
But very few indexes.
And the 'dimension' tables will have
user_id, use_level, etc
I repeat, do not normalize DATE / DATETIME / TIMESTAMP. It will hurt performance, not help.
As for further details, it is probably time to try to do the CREATE TABLE and the SELECTs. That will (1) help you work out some of the kinks, and (2) present the information to us in a standard way.
Subject
Written By
Posted
November 06, 2013 02:45PM
November 07, 2013 10:20PM
November 13, 2013 03:57PM
Re: Data Warehouse Design Help
November 14, 2013 05:53PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.