topic tMSSqlOutput Action on table in Talend Studio

tMSSqlOutput Action on table

Anonymous — Fri, 30 Aug 2013 19:44:31 GMT

From the Help:

Insert or update: inserts a new record. If the record with the given reference already exists, an update would be made.
Update or insert: updates the record with the given reference. If the record does not exist, a new record would be inserted.

Those sound awfully similar. Does one do inserts first and the other do updates first? What's the difference?

Re: tMSSqlOutput Action on table

Anonymous — Sat, 31 Aug 2013 16:32:19 GMT

Depends on what you think the probability of inserts vs. updates is.
If you think it is likely that you'll be mostly inserting, choose option 1. otherwise, choose option 2.
This should improve your overall throughput.
If you can predetermine inserts vs. updates...better still as 'upserts' are slow in comparison to choosing the correct action.