We Have the same issue here. Large Tables , loaded
nightly But nobody uses them. Management calls it a
Datawarehouse, I call it a data repository. Can a
cusotmer find out what they need. NOPE
Document your findings, to C.Y.A.
Good Luck
--- Orr, Steve [EMAIL PROTECTED] wrote:
When I was consulting at a particular client, I saw
the effects of this
approach after the fact. Massive amounts of data
were loaded into tables
that were never accessed except to load data because
the users couldn't do
anything with it. Later it was thought that to fix
this all they had to do
was send the users to training on the reporting
tool. After they spent lots
of money on training nothing changed because the
users still didn't
understand the data and couldn't do anything with
it. Meanwhile, damangement
checked off it's accomplishment of an objective on
the HR management
forms. I suspect that may be what you're dealing
with. After all, isn't it
more important to report that you did something that
to actually do
something worthwhile? ;-) The notion that DBA's
aren't needed and all you
have to do is load data into a relational database
and give the end users a
point and click GUI tool is foolish but not uncommon
with shortsided
damagement.
Steve Orr
-Original Message-
Sent: Tuesday, February 26, 2002 11:48 PM
To: Multiple recipients of list ORACLE-L
I've lost patience, my temper, and I'm about to quit
a job because the IT
manager has decreed that we will have his data
warehouse running within
24 hours, and we will use his design.
1 - We are NOT to use any kind of views, not even
materailzed views.
2 - we are not to do any computations, summaries or
rollups
3 - we are to have everything in one table
4 - the table name and column names will be
meaningful to any clerk
5 - we are not to start or snowflake designs.
That's just a bunch of
high power talk.
6 - all users will be trained to use MS Access to
get at their
data. (These are users that were just converted off
from green screen
teminals within the last 45-days, to Windows 98 with
64k RAM.)
7 - We are not to just copy the legacy transactions.
8 - We are to load into an Oracle table, all
legacy transction data
because we don't want to limit how or what a user
will look at
9 - It is not necessary to talk with the users to
see what data they want
to look at, or the atomic level. They are smart
enough to fighure this
out on their own. We just need to provide them the
data.
10 - There shall be no long term maintenance
required by the dw.
Any ideas on how to deal with this situation?
For tomorrow, I've done a CTAS from a materialized
view that we created to
support one departments known requirements.
Don
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Don
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: Orr, Steve
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).
__
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com
--
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).