Update Columns for Relational Targets
You can configure one or more fields as update columns to update or upsert data to relational targets.
The Mapping Configuration task uses an update column to update or upsert data in the target. When you select more than one update column, the Mapping Configuration task uses the AND operator with the update columns to identify matching rows.
When you use a parameter for the target connection or target object, you can configure update columns in the task.
Configuring Update Columns
You can configure update columns when you use the update or upsert operation to update data in a relational target.
1. In the Properties panel, click the Target tab.
2. Select a relational connection.
You can also use a connection parameter for a relational database connection type.
3. Select the target type that you want to use.
4. Select a target object.
5. Select the update or upsert operation.
6. To select update columns, click Add.
The Update Columns window displays all target columns.
7. Move the fields that you want to use from the Target Columns list to the Update Columns list.
8. Click OK.