I second that emotion. the guy that wrote it is a PhD
and owns Red Brick or something. totally knows what he
is talking about. One of my top five books, best
warehousing book by far I have ever read.
/jack silvey
- Jared.Still_at_radisys.com wrote:
> Yup, $60, and worth every penny.
>
> It may be 4 years old, but the information is still
> pertinent.
>
> Jared
>
>
>
>
>
> Joe Testa <jtesta_at_dmc-it.com>
> Sent by: root_at_fatcity.com
> 05/20/2002 05:53 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: 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).
>
>
>
> --
> 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).
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
INET: jack_silvey_at_yahoo.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 Tue May 21 2002 - 14:59:45 CDT
