DSXchange

Posted: **Thu Sep 16, 2010 9:52 pm**

Hi,

I am facing performance issue in loading data from sequentail file to partitioned table (Oracle EE stage) . The same file while loading through SQLLDR finishes in 1 min but takes 45 min when loading through datastage.
No of records in file: 350

There is no indexes in the target table and constraints were disabled in Oracle EE stage.

Please help me in this regard.

Thanks
Vinod

Posted: **Fri Sep 17, 2010 2:38 am**

Run in a single node config and check the ctl file.

Posted: **Fri Sep 17, 2010 5:13 am**

Changed the node as 1 and executed. Again same problem.

Posted: **Fri Sep 17, 2010 5:39 am**

Details, please, especially the options you are using in your target stage so we have some idea exactly what kind of 'load' it is doing.

Posted: **Sat Sep 18, 2010 3:51 am**

Thanks team. I have reset the ORACLE LOAD OPTIONS, with DIRECT=FALSE, then it worked out.

DSXchange

Loading issue in Partition table

Loading issue in Partition table