IKM Oracle Incremental Update Vs IKM SQL Control Append
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