topic Difference between "Update or Insert" and "Insert or update" in Talend Studio

Difference between "Update or Insert" and "Insert or update"

_AnonymousUser — Sat, 16 Nov 2024 13:25:28 GMT

Hello,
Sorry for that, but could somebody explain what the difference is between these two actions on tOracleOutput component? I'm not sure to understand...
Thanks in advance

Re: Difference between "Update or Insert" and "Insert or update"

Anonymous — Fri, 21 May 2010 15:37:28 GMT

Hello,
This is for optimization :
If you have more insert than update , you should use insert or update
If you have more update than insert , you should use update or insert
you save one query.