Performance issue in Oracle connector with multiple links
Posted: 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?
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?