gee, and here I thought all I had to do was put the book under my
pillow and let the words seep in through osmosis :)
- Jack Silvey <jack_silvey_at_yahoo.com> wrote:
> 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 <wisernet100_at_yahoo.com> 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
> >
> > --- 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
>
=== 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: Rachel Carmichael
INET: wisernet100_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 - 15:38:36 CDT