Chapter 10 Building Data Transformation Diagrams

Data Structure Mapping Editor

The Data Structure Mapping Editor allows you to visualize or define data structure columns in the Data Transformation Task Diagram. It is available from:

The contextual menu of all data transformation steps (data inputs, data outputs, and actions)
The data flow symbol
The Data Structure Columns tab of all data transformation steps (data inputs, data outputs, and actions) using the Open Mapping Editor tool

You can use the Data Structure Mapping Editor to represent the mapping between the data structure columns of the source and target objects of a data flow.

The output data structure of a step becomes the input data structure of the next step and a mapping is defined between the output of the previous step and the input of the current step:

Types of mapping

The object symbol from which you open the Data Structure Mapping Editor determines the type of mapping you can perform:

Open from a....	Description
Data input	Allows the mapping of a source PDM, XSM, BPM or flat file data structure columns to the current data input data structure columns
Action	Allows the mapping of the data structure columns of a previous step to the current action data structure columns
Data output	Allows the mapping of a target PDM, XSM, or flat file data structure columns to the current data output data structure columns
Data flow	Allows the mapping of the data structure columns of the source and target objects of the flow

The following illustration shows mappings between data structure columns in a Data Structure Mapping Editor open from a data flow symbol: