According to Gartner, only 25% of DW are loaded using ETL tools (Informatica, Datastage, Sagent, Data Junction,...), that means that all the others are loaded with good old cobol,pl/sql,...
ODBC to load ? Most ETL tools used ODBC to design the ETL mappings but they're using the native DB driver to load the data. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> a �crit : > Rich - > I don't claim to be a DW expert. My impression is > that what you have to > do for a DW will vary widely from site to site. > Also, much of the work may > be done by people besides yourself, and they may > elect to use tools besides > Oracle. > > I would consider a hierarchy of load/update tools to > be as follows: > 1. ODBC tools > 2. Oracle - SQL, PL/SQL, etc. > 3. O.S. tools > The ODBC tools are the most convenient, and may give > okay performance for > small amounts of data. You probably won't be using > them, so this means > someone besides yourself may be doing much of the > work. But for large data > sets, the performance may not be adequate. > For really large amounts of data, you may find it > necessary to process > data at the O.S. level before you load it into > Oracle. For example, you > might sort the data before loading it into Oracle. > SyncSort makes its money > by being faster than Oracle. > Updating just adds more complexity and more > variety to the tool set. You > must select a method based on your situation. > Bottom line, use whatever works, and the more > tools in your tool chest > the better. > Next week I plan to make up a list of 9i new > features that may be useful > for DW, to brief my DW developers. I'll send you the > list. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Wednesday, November 27, 2002 10:20 AM > To: Multiple recipients of list ORACLE-L > > > Yes, I know -- old topic, but a search thru the 440 > DW posts on the fatcity > archives didn't reveal much. > > Not having much of any knowledge on DW/DM, I picked > up the Oracle Press' > "Oracle8 Data Warehousing" book for $1 on the > clearance rack in hopes that > an overall view of the procedures necessary for > DW/DM building and > maintenance to give me some idea of what I'm up > against. > > I can't help but be completely confused by this book > because it doesn't seem > to cover DW/DM maintenance at all. It has a chapter > dedicated to various > ways to populate the DW/DM, but not how to keep the > data up-to-date. Do DWs > get completely regenerated on a > daily/weekly/periodic basis? This just > doesn't seem feasible to me, especially for large > (1T+) DWs. > > Am I missing something? Are newer revs of this book > better? Are there any > better DW books geared specifically for Oracle9i? > Does Martha know that > John is really her long-lost brother? > > From past posts (Jared's?), I'm thinking that we'd > be at least picking up > Kimball's DW Toolkit, 2nd Ed. and hopefully we'll > get some training in for > this, too, but I would like something specific to > DWs on Oracle 9i. > > > TIA! :) > Rich > > > Rich Jesse System/Database > Administrator > [EMAIL PROTECTED] Quad/Tech > International, Sussex, WI USA > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > 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: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > 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). > > ===== St�phane Paquette DBA Oracle et DB2, consultant entrep�t de donn�es Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __________________________________________________________ L�che-vitrine ou l�che-�cran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
