What is the difference between Insert or Update and Update or Insert - Cloud - 8.0

Version
Cloud
8.0
Language
English (United States)
Product
Talend Data Fabric
Talend MDM Platform
Module
Talend Studio
Content
Design and Development

What is the difference between Insert or Update and Update or Insert

As the names imply, the only difference between the two is which action is attempted first (Insert or Update):
Answer
  • Insert or Update : First tries to insert a record, but if a record with a matching primary key already exists, instead updates that record.

  • Update or Insert : First tries to update a record with a matching primary key, but if none already exists, instead inserts the record.

From a results point of view , there are no differences between the two, nor are there significant performance differences. In general , choose the action that matches what you expect to be more common: Insert or Update if you think there are more inserts than updates, Update or Insert if you think there are more updates than inserts.