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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] > 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: [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).