Oracle OCI Bulk load Vs Oracle Enterprise (Fast load)

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
zzgani
Participant
Posts: 6
Joined: Mon Mar 05, 2007 2:12 am
Location: Chennai

Oracle OCI Bulk load Vs Oracle Enterprise (Fast load)

Post by zzgani »

Hi,

We are planning to do a full refresh of our staging tables from the source system (Oracle ERP) on a daily basis. Our staging tables (Oracle 9i) in this case are just a mirror of the source tables (structurally same).
I would like to know which would be the appropriate stage (in terms of performance) to use Oracle OCI Bulk (load mode :automatic) or Oracle Enterprise (with write method as load and write mode as Truncate) .

We are new to Data stage and our priliminary POC indicated that Oracle Enterprise to be atleast two times faster than the Oracle OCI .

Would appreciate any thoughts on this :? .

thanks
zzgani
Top
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Enterprise edition with LOAD option uses the Fast load mechanism and OCI uses the SQL Loader. From Google, SQL Loader is seems to be faster that the other mehods.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”