RE: Manager decrees "his" data warehouse design. Help!

Maybe not the best advice. The job market is a bit rough at the moment. If you have a job I suggest keeping it unless you have a sure thing lined up.

Ethan

-----Original Message-----
[mailto:Scott.Shafer_at_dcpds.cpms.osd.mil] Sent: Wednesday, February 27, 2002 4:26 PM To: Multiple recipients of list ORACLE-L

Run, don't walk.

Scott Shafer
San Antonio, TX
210-581-6217

"Common sense will not accomplish great things. Simply become insane and desperate."

> -----Original Message-----
> From: Don [SMTP:dondealy_at_teleport.com]
> Sent: Wednesday, February 27, 2002 12:48 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Manager decrees "his" data warehouse design. Help!
>
> 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: Post, Ethan
  INET: Ethan.Post_at_ps.net

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