DataUpdate mapping

Use the DataUpdate node to make DataUpdate mappings, which update any existing database fields with new information. You cannot use this node to delete or insert fields that currently exist in a database; to perform these operations, use either a DataDelete node or a DataInsert node respectively.

For each type of DataUpdate mapping that is listed below, the number of rows that are updated depends on how many rows satisfy the user-specified condition. The condition is usually an operation involving one or more columns in the table. The tool generates the condition as a function of primary keys of the table.

One-to-one mappings are also allowed; in this case, the target column takes the value of the mapped input element. These insert statements can also be combined to produce a single insert that inserts several columns into the same row, as each insert statement creates a new row.

There are two ways to carry out this operation:

Edit the final WHERE clause of the combined mapping. Each pre-combination mapping already has a WHERE clause.

Related concepts
DataInsert mapping
DataDelete mapping
Warehouse mapping
Related tasks
Creating a mapping file
Developing mappings
Related reference
DataUpdate node
Mappings