Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

RE: Ab Initio, Unix Scripting, and Datawarehousing

Date: Wed, 19 Mar 2003 11:14:38 -0600
Message-Id: <>


  1. I don't recognize Ab Initio.
  2. For Unix scripting, there are several alternatives. You should first decide what you should learn (this list can help), before you spend a lot of time learning it. For example, I wasted a lot of time learning csh only to find it isn't a very good scripting language. Does your company have any standards (for scripting, that is)? I would normally recommend ksh, but if you want something that will run on Windoes as well, you may want to consider Perl. This ties to your question #3. The appropriate tool(s) will vary by DW, depending on the needs.
  3. Oh yeah, really different. It starts with the mindset. If you are a normalization bigot, you are in trouble. I find warehouses are much more different from each other that OLTP systems are different. Therefore it is very hard to create simple rules to follow. Are you designing the DW or just working on a DW that someone else designed?

Dennis Williams
Lifetouch, Inc.

-----Original Message-----
From: [] Sent: Wednesday, March 19, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L Subject: Ab Initio, Unix Scripting, and Datawarehousing

  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


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:

Author: <

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (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). Received on Wed Mar 19 2003 - 11:14:38 CST

Original text of this message