Configure update columns when the target table does not contain a primary key and the mapping uses an update, upsert, or delete operation. When you select more than one update column, the mapping uses the AND operator with the update columns to identify matching rows.

When you run the mapping, it uses the field mapping to match rows in the upstream transformations to the target table. If the

mapping

task matches an incoming row to multiple target rows, it performs the specified task operation on all matched target rows.

When you use a parameter for the target connection or target object, you can configure update columns in the

mapping

task.