Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Data Warehouse experts, a simple question for you
Joe,
Add a generated PK to the time dimension. The PK is stored as an FK in the fact table.
That way you can select from the time dimension by year, day, qtr,
whatever,
and easily pick out the correct fact table rows.
"The Data Warehouse Lifecycle Toolkit" includes a spreadsheet to generate the DDL/DML for a very robust time dimension. I think it has about 20 columns.
Very good book, can't recommend it enough.
Jared
Joe Testa <jtesta_at_dmc-it.com>
Sent by: root_at_fatcity.com
05/20/2002 04:08 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: Subject: Data Warehouse experts, a simple question for you
Ok i'm messing with dimensions.
dm_time to be exact:
create table dm_time
( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) not null);
insert into dm_time values(to_date('20020101','YYYYMMDD'), 1,1,2002); insert into dm_time values(to_date('20030101','YYYYMMDD'), 1,1,2003);
2 rows nice and simple
trying to validate the dimension comes up with an error, my guess is because of the design of the table
where basically calendar_date is child of
calendar_month is child of calendar_qtr is child of calendar_year, wont validate.
Was the design of dm_time just dont wrong or am i missing something here.
thanks, joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: jtesta_at_dmc-it.com
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: ListGuru_at_fatcity.com (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Jared.Still_at_radisys.com
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: ListGuru_at_fatcity.com (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). Received on Mon May 20 2002 - 19:03:23 CDT