Just wanted to reiterate the grain recommendation. The growth rate of our
data warehouse increased app. 20x when the business side changed their mind
from monthly to daily on our largest fact table. They did this one week
after we got the monthly table into production as per their original
requirements.
Had to redo all the tablespace structures to make it easier save historical
data to tape and drop it from the database. We now have 13 tablespaces each
of which will be holding one month's worth of data.
-----Original Message-----
Sent: Friday, May 03, 2002 10:18 PM
To: Multiple recipients of list ORACLE-L
Excellent dude.
-----Original Message-----
WILLIAMS
Sent: Friday, May 03, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L
Ralph Kimball warns that often people
will get the grain wrong. They will size it for data summarized at the
weekly level, then after it is built they will realize that isn't going to
cut it and need a daily level. You must start almost from scratch and get 7
times the disk capacity. That is the fun side of being a DW DBA. Your
cynical instincts will still serve you well, just get them away from
normalization and worry about getting the grain right.
Okay, I've rambled along here too long. Hope that gets you off on
the right foot.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
