Data Warehouse experts, a simple question for you

From: Joe Testa <jtesta_at_dmc-it.com>
Date: Mon, 20 May 2002 15:08:25 -0800
Message-ID: <F001.004655A7.20020520150825@fatcity.com>

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.

• the question i have is this, should month really be like 2002-01 with the year included, likewise with qtr, then it will validate ok.

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). Received on Mon May 20 2002 - 18:08:25 CDT