Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g4M3VBv29203 for ; Tue, 21 May 2002 23:31:11 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id MAA58770; Tue, 21 May 2002 12:28:33 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 004666B9; Tue, 21 May 2002 12:08:32 -0800 Message-ID: Date: Tue, 21 May 2002 12:08:32 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Jack Silvey Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Jack Silvey Subject: Re: Data Warehouse experts, a simple question for you Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 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@radisys.com wrote: > > Yup, $60, and worth every penny. > > > > It may be 4 years old, but the information is > still pertinent. > > > > Jared > > > > > > > > > > > > Joe Testa > > Sent by: root@fatcity.com > > 05/20/2002 05:53 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list > ORACLE-L > > > > 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@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 > > >Sent by: root@fatcity.com > > >05/20/2002 04:08 PM > > >Please respond to ORACLE-L > > > > > > > > > To: Multiple recipients of list > ORACLE-L > > > > > 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@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@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@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@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: Rachel Carmichael > INET: wisernet100@yahoo.com > > 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: jack_silvey@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@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).