Oracle-L: RE: Data Warehouse experts, a simple question for you

From: Wong, Bing <bing.wong_at_IngramMicro.com>
Date: Mon, 20 May 2002 15:40:03 -0800
Message-ID: <F001.00465631.20020520154003@fatcity.com>

calendar_date	calendar_month	calendar_qtr	calendar_year
20020101	1		1		2002
20030101	1		1		2003

Mhhhhh...

The calendar_date(or changed to calendar_day) should be just the day of the month since you already have calendar_year. It seems that you are storing everyday's day.
Or get rid of calendar_year and calendar_month since calendar_date contains month, and year?

-----Original Message-----
Sent: Monday, May 20, 2002 4:08 PM
To: Multiple recipients of list ORACLE-L

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Wong, Bing
INET: bing.wong_at_IngramMicro.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------