RE: What tools for Oracle Data Warehouse ETL

• Chuan Zhang <Chuan.Zhang_at_transact.com.au>

>
> Thanks Jared for your invaluable information.
>
> One more question,
> To my very little knowledge about these tools(DataStage, Informatica),

You left out Ab Initio. Probably the best thing going for heavy-duty processing.

> do these tools generate Oracle executable scripts for ETL process? To my
> knowledge, OWBuilder(Oracle Warehouse Builder) is a good one for me at
> this moment in the sense of its 100% compatibile with Oracle. But I
> cannot get evaluation on "to what extents to use it to create ETL".
> Maybe somewhere outside, such as Quest product, got such a kind of
> tool.

Ideally you'd want to avoid sql-loader like the plague and have the product load directly. Every project I've been on that used Oracle's loading software got bottlenecked to the point of severe pain.

--
Steven Lembark                               2930 W. Palmer
Workhorse Computing                       Chicago, IL 60647
                                            +1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: lembark_at_wrkhors.com

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: 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).