it's cheaper on bookpool :)
especially when Borders is out of stock
you guys are killing my credit card! I went out and bought Inmon's
Building the Data Warehouse, BOTH Kimball books and and considering the
Webhouse one as well.... geez, when do I have time to READ this stuff?
Rachel
--- [EMAIL PROTECTED] wrote:
> Yup, $60, and worth every penny.
>
> It may be 4 years old, but the information is still pertinent.
>
> Jared
>
>
>
>
>
> Joe Testa <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 05/20/2002 05:53 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject: Re: Data Warehouse experts, a simple question
> for you
>
>
> looks like published aug of 98 for that book?, like $60?
>
> joe
>
>
> [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>
> >Sent by: [EMAIL PROTECTED]
> >05/20/2002 04:08 PM
> >Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: Rachel Carmichael
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
