DSXchange

Hello Ray,

Thanks a lof for the valuable information.

Hello Ray, Thanks a lot for the prompt reply. I undertand that splitting into two streams, insert and update, will give us best performance but since the target table is too large, I chose not to take that approach. Since also I am aware that the data contains more inserts at any given time, I would...

Hello All, In the ORACLE OCI EE stage there are two Upsert Order modes: Insert then Update & Update then Insert. My question is, how do we improve the performance of a Parallel job for which the Upsert order is set to "Insert then Update" on a given day when there are more or all updates as comp...