I find that if I wrap my books in Saran Wrap, I can
read in the shower. And if you prop the book up on
your shoulder, you can read it backwards in the
rearview mirror during drive time. Also, if you learn
to read in your sleep, you can get LOADS of stuff
done.
;)
hth,
/jack silvey
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> 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)
=== message truncated ===
__________________________________________________
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: [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).
