: Data Warehouse
experts, a simple question
for you| Outdated?
Dennis,
I have on my desk, all in varying stages of being
read:
Inmon's book Building the Data Warehouse (very
understandable)
Kimball's articles from his site and from
, Ian A. [EMAIL PROTECTED]
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
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
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 in. The first release of the
Data
Warehouse Toolkit defines a data warehouse much as a data mart
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 in. The first release of the
Data
Warehouse Toolkit defines a data warehouse much
-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
[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
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 book
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
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
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
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.
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.
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
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's book Building the Data Warehouse
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Data Warehouse experts, a simple
question
for
you| Outdated?
=== message truncated ===
ATTACHMENT part 2 application/octet-stream name=STG05064
by: [EMAIL PROTECTED]
23-05-2002 11: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
: 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 can be found at
http://www.datawarehousing.com/, or at least
-
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
gee, and here I thought all I had to do was put the book under my
pillow and let the words
:
Subject: RE: Data Warehouse experts, a
simple
question for you
05/21/2002
08:28 PM
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 in. The first release of the Data
Warehouse
[EMAIL PROTECTED]
Sent by: rootcc:
Subject: RE: Data Warehouse
experts, a simple
question for you
05/21/2002
08:28 PM
MacGregor, Ian A. [EMAIL PROTECTED]
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
:
Subject:
RE: Data Warehouse
experts, a simple
question
for you
05/21/2002
08:28 PM
Please
respond to
ORACLE-L
.us
[EMAIL PROTECTED]
Sent by: rootcc:
Subject:
RE: Data Warehouse
experts, a simple
question
for you
05/21/2002
of
list
ORACLE-L
.us [EMAIL PROTECTED]
Sent by: rootcc:
Subject: RE: Data Warehouse
experts, a simple
question for you
05/21/2002
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 think of a data warehouse as having a highly normalized
structure which stores
:
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
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
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
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
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
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 question for you
gee
: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
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
.
-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
gee, and here I thought all I had to do was put
the book
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 there? Does
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
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 question for you
gee, and here I
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
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
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
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
43 matches
Mail list logo
