DataInsert mapping

Make DataInsert mappings using the DataInsert node, which lets you create and populate new database records. You cannot delete or update information currently held in an existing database field using this node. To do this, use either a DataDelete node or a DataUpdate node respectively.

In a default generated DataInsert mapping, each value of a repeatable element instance is inserted into the selected column in a row. The number of inserts depends on the number of instances.

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:

Related concepts
DataUpdate mapping
DataDelete mapping
Warehouse mapping

Related tasks
Creating a mapping file
Developing mappings

Related reference
Datalnsert node
DataDelete node
Mappings