Performance issue in Oracle connector with multiple links

bj_ds7 · Post by **bj_ds7** » Tue Apr 15, 2014 9:17 am

In our job we have a single Oracle connector with 3 links connected to it, loading 3 different table as a part of same transaction. Each link loads 1 million records to a different table. Array size is set to 2000.

During the job run, even though performance statistics show all records are loaded to the target connector, connector job is taking time to get finished. Its taking 2 hours. Guess the buffering to commit records in database side slows down. How can I improve the performance when multiple input links are used to a single Oracle target connector?

yugee · Post by **yugee** » Tue Apr 22, 2014 4:03 pm

This article from IBM explains Oracle Connector (you can read specifically - Parallelism and partitioning part for your issue) very usefull and in-detail explanation of different aspects.

http://www.ibm.com/developerworks/data/ ... onnector1/