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).