Oracle Incremental Update(merge) in ODI 11g.

When we want to run an incremental load in ODI 11g, which is the best IKM that will improve our performance.

• IKM Oracle Incremental Update (Merge).

IKM Oracle Incremental Update(Merge) uses mainly the following logic for incrementally load the data.

• First load data to the C$ table from source.
• Then minus C$ table from target table(In this step updated records and inserted records are selected). 
• Then load the updated and newly inserted records to I$ table.
• In the last step it does a merge operation with I$ and Target table.

So go for oracle incremental update(Merge) for optimizing your Incremental update.