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

Hi Yechiel,

Thx. The hardest thing for me to do is step back and let management micro manage technical issues about which they know nothing, and apply resources where they see fit. After a group therapy session with the cobol folks, we were all in a much better mood.

Did we meet the 24-hour deadline with the single table design the mngr wants? We still don't know, because the IT mngr postponed the demo and is taking PTO until next week sometime.

At 2/28/02, you wrote:
>Hello Don
>
>In a more serious mood: DO IT.
>I also had some arguments with my boss over the years and except
>for 2-3 cases (in 20 years) that I told my boss that I will not do something
>and if he wants it he can do it himself, my motto was if he wants to waste
>resources for something that is obviously an error let him waste it.
>He wants you to waste time and disk space on a system that the users
>will not use: waste your time and the resources. He is management and
>he is the one who calls the shots.
>Just document everything to cover yourself later.
>
>Yechiel Adar, Mehish Computer Services
>adary_at_mehish.co.il
>
> > -----Original Message-----
> > From: Don [SMTP:dondealy_at_teleport.com]
> > Sent: Wed, February 27, 2002 8: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: Don
> > INET: dondealy_at_teleport.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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
> INET: adary_at_mehish.co.il
>
>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: Don
  INET: dondealy_at_teleport.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).