Warehouse mapping

Warehouse mappings use the Warehouse node, which lets you create new database records. You cannot delete or update information currently held in an existing database field. To do this, use either a DataDelete node or a DataUpdate node respectively. The key difference between this type of mapping and that provided by the DataInsert, DataDelete, and DataUpdate nodes is that interaction is restricted to storing the entire message, or parts of the message, or both, in a table within the database.

Warehouse mappings are specialized data insert mappings. Mappings in a Warehouse node are intended for archival purposes; only one-to-one mappings are allowed, and no modifications are permitted for assignments in a warehouse assignment. 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:

You cannot merge mappings with the same target; this leads to an ambiguous mapping, because it is an overwrite. Creating one mapping before or after another mapping does not guarantee that the mappings are executed in order (or reverse order) of creation; mapping execution is arbitrary during runtime.

You can use the Map Entire Message option only once for each Warehouse node. If you want to use this option on another Warehouse node, first delete the existing mapping currently using it.

Related concepts
Mappings
Mapping types
Message mapping
Related tasks
Developing mappings
Related reference
Warehouse node
Mappings