update then insert

hargun · Post by **hargun** » Fri Apr 01, 2016 12:59 pm

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.

chulett · Post by **chulett** » Fri Apr 01, 2016 1:30 pm

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.