DSXchange

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

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.