DSXchange

hi,

I have job from db2 to oracle and below is the process to inert the records

1.Push the records from db2 to oracle one time
2.push the delta(changes) daily

can I use insert then update in oracle connector or update then insert.Please advise.

Short answer? Yes. Use whichever has the most frequent action first. If mostly inserts chose "Insert then Update". Etc. Of course there's more to it than that but... yes.