DataInsert mapping

Use the DataInsert node to make DataInsert mappings, which create and populate new database records. You cannot use this node to delete or update information that is currently held in an existing database field; 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 operation 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:
Related concepts
DataUpdate mapping
DataDelete mapping
Warehouse mapping
Related tasks
Creating a mapping file
Developing mappings
Related reference
Datalnsert node
DataDelete node
Mappings