received this
> > transmission in error, please
> > > delete it and notify the sender. The contents of
> > this e-mail are the
> > > opinion of the writer only and are not endorsed by
> > the Mincom Group
> > > of
> > > compan
RACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Data Warehouse experts, a simple question for you| Outdated?
>Date: Thu, 23 May 2002 07:33:26 -0800
>
>Rachel
> - Glad Inmon's book is working for you. I have only read (or more
>correctly attempted to read) his articles, which c
> >
> >
> >
> >
> > Rachel Carmichael <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 23-05-2002 11:13 PM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list
> ORACLE-L
>
1:13 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Fax to:
> Subject:RE: Data Warehouse experts, a simple question
> for you| Outdated?
>
>
> Dennis,
&g
pond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Fax to:
Subject: RE: Data Warehouse experts, a simple question for you|
Outdated?
Dennis,
I have on my desk, all in varying stages of being read:
Inmon&#x
I have NOT read his articles. Nor have I gotten all THAT far into the
book
however, the prep work I did before starting his book (reading the
Oracle docs, reading some Kimball articles, searching the web) may be
the reason I find him readable.
Of course, it could just be that I am smarter than a
Jared - Hmmm. . . if Rachel finds him very readable, does that mean:
a) she will shortly explain Inmon to the rest of us dumb DBAs.
b) she will become incomprehensible to the rest of us.
Sorry Rachel, couldn't resist. Actually, I am hoping for option A.
Dennis Williams
DBA
Lifetouch, Inc.
Rachel,
Having the same backup problems as talked about in the article, I can
agree with the views and opinions of the author. The second part of the
article dealt with the placement of the data and type of operation on
the data in the same instance.
I have mixed emotions about that idea.
W
Dennis Williams wrote:
> Personally, I have understood everything that Kimball has
> written and have never been able to read one of Inmon's articles to the
end.
> But maybe that is just me.
No, it's not just you. I can't read him either. It's like taking
a walk through a briar patch without a
ron,
Even without reading the rest of the article, my first instinct is to
scream NOO
and, after reading the article, it appears the author agrees with me.
I have a sane boss. an intelligent boss. He is management, not
damagement he has the same concerns about what the
Rachel,
This was just received from the "SearchDatabase" email and I thought
it might be of interest to you.
.
TODAY'S BI STRATEGY: Placement of the data warehouse (Part 2)
By William McKnight, SearchCRM Expert
Another question I received [last week at the Data Warehousing
Insti
Dennis,
We are active participants in the process. We are also making an offer
to someone with an extensive background in developing data warehouses,
which will help me to sleep much more comfortably at night :)
Rachel
--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Rachel
> - Glad Inmon's b
it was Richard Winter?
> >
> > Anyway, I guess that part is a bit dated. There is so much good
> > information
> > in that book though, that it's still worth its weight in gold. You
> > won't
> > find too many
> > publications for $60 that will take yo
sure that I've seen
> > Inmon
> > refer to them that way, or maybe it was Richard Winter?
> >
> > Anyway, I guess that part is a bit dated. There is so much good
> > information
> > in that book though, that it's still worth its weight in gold. Yo
There is so much good
> information
> in that book though, that it's still worth its weight in gold. You
> won't
> find too many
> publications for $60 that will take you step by step through building
> an
> entire
> data warehouse, including the infrastr
Winter?
>
> Anyway, I guess that part is a bit dated. There is so much good
> information
> in that book though, that it's still worth its weight in gold. You
> won't
> find too many
> publications for $60 that will take you step by step through building
> an
>
n,
> >
> > Good question. I think that I've seen more
> recenct references in
> > articles
> > that state the current thinking of DW/DM. I'm
> sure that I've seen
> > Inmon
> > refer to them that way, or maybe it was Richard
> Winter?
&g
at will take you step by step through building
> an
> entire
> data warehouse, including the infrastructure.
>
> Jared
>
>
>
>
>
>
> "MacGregor, Ian A." <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 05/21/2002 05:48 PM
> Pleas
RACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Data Warehouse experts, a simple question for
you| Outdated?
I am new to his books, three chapters in. The first release of the "Data
Warehouse Toolkit" defines a data warehouse much as a data mart is today.
Today we
@doh.state.flTo: Multiple recipients of
list
ORACLE-L
.us <[EMAIL PROTECTED]>
Sent by: root cc:
Subject: RE: Data Warehouse
experts, a simple
TECTED]>
> Sent by: rootcc:
> Subject:
> RE: Data Warehouse
> experts, a simple
> question
> for you
> 05/21/2002
> 08
Sent by: rootcc:
> Subject:
> RE: Data Warehouse
> experts, a simple
> question
> for you
> 05/21/2002
> 08:28 PM
>
To: Multiple recipients of list ORACLE-L
>
>
> 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/
@doh.state.flTo: Multiple recipients of list
ORACLE-L
.us <[EMAIL PROTECTED]>
Sent by: root cc:
Subject: RE: Data Warehouse
experts, a simple
quest
gt;
Sent by: [EMAIL PROTECTED]
05/21/2002 05:48 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|
Outdated?
I am new to his books, three chapters
Sent by: rootcc:
Subject: RE: Data Warehouse experts, a
simple
question for you
05/21/2002
> at hand, though.
>
> > -Original Message-
> > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, May 21, 2002 4:39 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Data Warehouse experts, a simple question for you
>
enny.
> > > > >
> > > > > It may be 4 years old, but the information is
> > > > still pertinent.
> > > > >
> > > > > Jared
> > > > >
> > > > >
> > > > >
> > > > >
> > &g
D
> and a chicken wing apart. Make sure that you have few gallons of
> water
> at hand, though.
>
> > -Original Message-
> > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, May 21, 2002 4:39 PM
> > To: Multiple recipients of list ORACL
ion 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 simp
Title: RE: Data Warehouse experts, a simple question for you
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
ou have
> few gallons of water
> at hand, though.
>
> > -Original Message-
> > From: Rachel Carmichael
> [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, May 21, 2002 4:39 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Data Warehouse expe
ation is
> > > still pertinent.
> > > >
> > > > Jared
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Joe Testa <[EMAIL PROTECTED]>
> > > > Sent by: [EMAIL PROTECT
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 wa
apart. Make sure that you have few gallons of water
at hand, though.
> -Original Message-
> From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 21, 2002 4:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Data Warehouse experts, a simple q
pertinent.
> > >
> > > Jared
> > >
> > >
> > >
> > >
> > >
> > > Joe Testa <[EMAIL PROTECTED]>
> > > Sent by: [EMAIL PROTECTED]
> > > 05/20/2002 05:53 PM
> > > Please respond to ORACLE-L
>
ed
> >
> >
> >
> >
> >
> > 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
&
cipients 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:
>
ease 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 $
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.
&g
red
>
>
>
>
>
>
>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:
ents 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_date calendar_month calendar_qtrcalendar_year
200201011 1 2002
200301011 1 2003
Mh...
The calendar_date(or changed to calendar_day) should be just the day of the
month since you already have calendar_year
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','MMDD'), 1,1,2002);
insert into
44 matches
Mail list logo
