DSXchange

Posted: **Tue Feb 03, 2015 9:56 am**

Hi All,

We are using Datastage 9.1 parallel jobs. Database is Oracle 12C. When we try to read and write the recods by using odbc connector stage , we could see the performance of the job is very less.

Kindly through me some inputs by increasing the performane or re-design the job as well.

Posted: **Tue Feb 03, 2015 3:33 pm**

ODBC is necessarily slower than native connectivity, not least because of the extra layer of software (the ODBC driver) that has to be involved.

Try using a native Oracle stage; for preference the Oracle Connector stage.

Posted: **Tue Feb 03, 2015 4:18 pm**

satheesh_color wrote:we could see the performance of the job is very less

Compared to what?

DSXchange

odbc connector stage performance issue on Oracle 12 C

odbc connector stage performance issue on Oracle 12 C

Re: odbc connector stage performance issue on Oracle 12 C