This section provides information about the Mapping component.
Drag and drop the Mapping component on the canvas to
define a mapping. Connect the inputs and outputs for the Mapping
component before specifying the mapping details.
To position the component on the canvas, drag and move the component, or click
the component and use arrow keys on the keyboard to move it around.
Double-click the Mapping component on the canvas. The
EDDs, ADIs, and their respective data/derived data elements are displayed in the
Mapping window.
Filter the source attributes by selecting an option from the drop-down list.
Click a data element under Source.
Filter the target attributes by selecting an option from the drop-down list.
Click a data element under Target. and then click the
Map button. The column mappings are displayed.
Click the Map button. The mapped items are displayed on
the right. column mappings are displayed.
Repeat the steps to map as many source-target pairs as required. Note that you
can use the filter icons for the Source and
Target lists to filter unmapped, mandatory, or those
items that are valid for the application.
The following validations are performed for the mapping:
Data type validation
Data length validation
Data precision validation
The result of the validation for each mapping is indicated as
Remarks next to each mapping.
At any given time, you can select the Unmap button to
unmap the source and target.
Click Auto Map to auto map a source and target.
Note:
Auto-mapping is done by
matching the logical/physical column name of both the source and
target.
Hover your mouse over a data element under Target column
to see detailed information which includes the description, length, and
scale.
Use the search icons to search for source or target data elements.
Click the Delete All icon to delete all the mappings.
You can also delete individual mappings by selecting the cross symbol next to
the column mapping.
Click the Import Mapping icon to import a mapping Excel
sheet.
Click the Export Mapping icon to export the mapping
information in an Excel format.
Use the search field to search for mappings. You can search for an item based
on the Source Column Name, Target Column
Name, Source Entity, Target
Entity, or Remarks.