Oracle-L: RE: Data Warehouse experts, a simple question for you

From: Thomas Day <tday6_at_csc.com>
Date: Wed, 22 May 2002 06:38:38 -0800
Message-ID: <F001.004678EB.20020522063838@fatcity.com>

Try running:

select 'IT DOES' from dual where 2 = '02';

I guess that SQLPlus is doing an implicit data conversion.

                                                                                           
                    Paula_Stankus                                                          
                    @doh.state.fl        To:     Multiple recipients of list ORACLE-L      
                    .us                  <ORACLE-L_at_fatcity.com>                            
                    Sent by: root        cc:                                               
                                         Subject:     RE: Data Warehouse experts, a simple 
                                         question for you                                  
                    05/21/2002                                                             
                    08:28 PM                                                               
                    Please                                                                 
                    respond to                                                             
                    ORACLE-L

Okay you guys are silly. I have probably a stupid basic question to ask. How important is it to store data (let's say state codes, county codes with leading zeroes as character versus numeric). What is the standard out there? Does '02' mean the same thing as 2 for state code if you are consistent throughout your warehouse or do we need to consider other datasets out there that might be linked maybe sometime in the future? Can I leave it as is numeric and create materialized views with it padded or should I bite the bullet and reload into char/varchar2 datatypes?

-----Original Message-----
Sent: Tuesday, May 21, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L

Yeah, that's a common misconception. You actually have to prop the book on your forehead since English flows to the left and downwards. I have heard that Chinese flows from right to left and upwards or something though - you might consider taking it up as a new language if you are set on the underpillow method of knowledge transfer.

/jack

Rachel Carmichael <wisernet100_at_yahoo.com> wrote:
> 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
>
=== 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_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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thomas Day
  INET: tday6_at_csc.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 Wed May 22 2002 - 09:38:38 CDT