Using key and update columns

The data produced by a mapping operation can be inserted as new rows in a database table or can update only specific columns in a table as designated.

Designate particular columns in a table to be used as key columns determining whether output data updates an existing row or whether it is inserted as a new row in the table or view. In addition to specifying key columns, you can designate the columns in a table that will be affected by any update operation. You define the columns to update.

The term key in this usage does not necessarily mean that the column is part of a database primary or foreign key.

For any update to be performed, update mode must be specified for the target. This is accomplished by specifying the Update adapter command (-UPDATE) in the PUT > Target > Command settings using the Map Designer or Integration Flow Designer, or by passing it with the override execution command on the command line at execution time. For more information about how to enable update mode, refer to Specifying update mode.