Warehouse mapping

Use the Warehouse node to make Warehouse mappings, which create new database records. You cannot use this node to delete or update information that is currently held in an existing database field. To perform these operations, use either a DataDelete node or a DataUpdate node respectively. The key difference between a Warehouse mapping and a mapping that is provided by the DataInsert, DataDelete, and DataUpdate nodes is that in a Warehouse mapping, 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 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:

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 run time.

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 that is currently using it.

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