DataUpdate mapping

DataUpdate mappings use the DataUpdate node, which lets you update any existing database fields with new information. You cannot delete or insert fields currently existing in a database using this node. To do this, use either a DataDelete node or a DataInsert node respectively.

For each type of DataUpdate mapping 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 value that the target column takes is 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.

To carry out this operation, highlight the selected elements in the Outline perspective and either:

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