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 is taking more than 24 hours to load 6lakh+ records

2605470Apr 5 2014 — edited Apr 7 2014

Hi All,

I have an iterface with source and target on two different servers.There are couple of validations on the source data.The requirement is that new records have to be inserted and existing records have to be updated. My interface is stuck at loading the flow(I$) table and is running for so long. Below are the details of KM's i have used. any help on this is highly appreciated.

LKM: lkm sql to sql

IKM: IKM Oracle incremental update

Detection strategy: not _exists

CKM : CKM Oracle

Thanks,

This post has been answered by JeromeFr on Apr 7 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2014

Added on Apr 5 2014

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

5 comments

2,556 views