Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Interface Performance Improvement

894315Mar 12 2012 — edited Mar 13 2012

Hi,

ODI Version 11G

I have created some interface and package to upload data from Oracle SQL database to MS SQL . However the interfaces are running very slow and take 8-10 minutes to complete.

Source – Oracle SQL
Target - MS SQL
IKM – IKM MS SQL Incremental Update
CKM – CKM SQL
LKM – LKM SQL to MS SQL

Could you please suggest me some performance tuning help or alternative faster way to get this task done.
Any suggestions is highly appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2012

Added on Mar 12 2012

#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration

4 comments

768 views