Data Transformation Engine Database Interface Designer Reference Guide

Database Interface Designer Reference Guide
101
Chapter 6 - Updating Database Tables
This chapter discusses how you can designate specific columns in your database to
be updated with data produced by a mapping operation.
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.
Note 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 later in this chapter.