When using ETL tools, most DW sites use Informatica or Data Stage. According to Gartner, 75% of DW are loaded with in house scripts.
Stephane -----Original Message----- WILLIAMS Sent: Wednesday, March 19, 2003 2:00 PM To: Multiple recipients of list ORACLE-L RG This tool will only be worth it if your prospective employer purchased this particular tool. Another approach is to find what most DW sites use again and again. Like ksh. Like SQL*Loader. You could even write some useful utilities and scripts to impress a prospective employer. Like a ksh script that generates a SQL*Loader control file. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, March 19, 2003 11:50 AM To: Multiple recipients of list ORACLE-L been to their website and cant find the free download. Any idea what the learning curve is on Ab Initio? I constantly try to improve my skills and Im trying to decide whether this is worth the time at the moment. > > From: "BALA,PRAKASH (HP-USA,ex1)" <[EMAIL PROTECTED]> > Date: 2003/03/19 Wed PM 12:13:55 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Ab Initio, Unix Scripting, and Datawarehousing > > 1. It's an ETL tool like Informatica. Heard it's much better than > Informatica. You need to check their website for further information. > > 3. You just deal with a lot of data at one time and so keep in mind to > optimize your code so that the end-to-end processing time is less. > > HTH > Prakash > > -----Original Message----- > Sent: Wednesday, March 19, 2003 09:19 > To: Multiple recipients of list ORACLE-L > > > 1. Has anyone ever used Ab Initio? Is it some kind of data conversion tool? > What is the the learning curve on it? Is there online documentation and do > they > have a freeware version to download? I want to learn it. Dont want to use it > > for development. > > 2. What is a good Unix scripting book for Oracle Developers? Dont need a > Using > Oracle as a DBA on Unix. Just one on basic scripting. My Unix skills are > weak > and I want to improve them. I have Redhat at home. What should I concentrate > > on? > > 3. In theory I know the difference between a datawarehouse and an OLTP, but > as > a developer is the work really that different? I understand star schemas > etc... > Just need to know how different the work is. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > 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.net > -- > Author: BALA,PRAKASH (HP-USA,ex1) > 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.net -- Author: <[EMAIL PROTECTED] 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.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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).
