Update columns are columns that uniquely identify rows in the target table. Add update columns when the database target table does not contain a primary key and the
synchronization
task uses an update, upsert, or delete task operation.
When you run the
synchronization
task, the
synchronization
task uses the field mapping to match rows in the source to the database table. If the
synchronization
task matches a source row to multiple target rows, it performs the specified task operation on all matched target rows.