Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Ab Initio, Unix Scripting, and Datawarehousing

RE: RE: Ab Initio, Unix Scripting, and Datawarehousing

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Wed, 19 Mar 2003 15:37:23 -0500
Message-Id: <24715.322434@fatcity.com>


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-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of DENNIS WILLIAMS
Sent: Wednesday, March 19, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L Subject: RE: RE: Ab Initio, Unix Scripting, and Datawarehousing

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.
dwilliams_at_lifetouch.com

-----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)" <prakash.bala_at_hp.com>
> Date: 2003/03/19 Wed PM 12:13:55 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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: <rgaffuri_at_cox.net
> INET: rgaffuri_at_cox.net
>
> 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: 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.net
> --
> Author: BALA,PRAKASH (HP-USA,ex1)
> INET: prakash.bala_at_hp.com
>
> 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: 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.net
--
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

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: 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.net
--
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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: 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
Received on Wed Mar 19 2003 - 14:37:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US