Re: Data Warehouse experts, a simple question for you

looks like published aug of 98 for that book?, like $60?

joe

Jared.Still_at_radisys.com wrote:

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