mapping

Mapping

Icon
Use When	Data needs to be mapped from one set of entities/attributes (model structure) to another set of entities/attributes
Samples	Flat File to Relational Database, Normalized Table to Denormalized File, Partition by Gender
Description	The mapping component allows you to map messages from one model structure to another.
Inbound Message Type	Model Based Message
Output Message Type	Model Based Message

Parameters

Name	Description
Input Model
Output Model
Enabled
Set Unmapped Attributes To Null	Whether attributes in the output model that don’t have a mapping specified from the input model should be set to null.
Entity Per Record	Determines whether inbound records will be split into multiple output records, one for each entity. Defaults to false. If set, the output model will have null values for every entity/attribute combination that is in the output model but not mapped from the input model. If not set, the output model will not contain entities/attributes that are not mapped from the input model.
Log Input
Log Output
Inbound Queue Capacity
Shared

Component Editor

Double clicking on the Mapping component in the flow will result in the Mapping editor being displayed as shown below.

The Mapping editor displays the input model on the left hand side of the screen, and the output model on the right hand side of the screen. Data can be mapped from the input model to the output mode by:

• Clicking on an attribute in the input model and dragging until your mouse cursor is over the desired output model attribute

• Clicking on an attribute in the input model, then clicking again on the desired output model attribute

Tip	For large models, typing an entity or attribute name in the Filter box will narrow the displayed model to entites or attributes matching the Filter criteria.

The AutoMap feature will look at both input and output models and attempt to map the models based on similarly named attributes.