Skip to Main Content

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!

IKM Oracle Incremental Update Vs IKM SQL Control Append

user452108Jul 23 2010 — edited Jul 27 2010
We are going to load lot of files in PARALLEL (Asynchronous mode) on a day to day basis. We are developing interfaces to load these files into Oracle database. Volumes of data can be large at times. Which IKM (IKM Oracle Incremental Update Vs IKM SQL Control Append) is better to use in the interfaces ?. If we use IKM SQL Control Append, will it cause any problems if we load several files in parallel (Asynchronous mode) as this IKM loads target table in replace mode. I am not sure what this replace mode does ? Will it truncate temporary tables for every load ?

I would appreciate if someone clarifies and suggest what's the best way to use any of these IKMs in designing interfaces.

Thanks,
RP
This post has been answered by Guru Sankar on Jul 27 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2010
Added on Jul 23 2010
3 comments
8,522 views