ODI Interface Performance Improvement
894315Mar 12 2012 — edited Mar 13 2012Hi,
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.