Creating a mapping using the Create Mapping tool from the Mapping Editor toolbar

Chapter 16 The Mapping Editor

Creating a mapping using the Create Mapping tool from the Mapping Editor toolbar

You can create a mapping using the Create Mapping tool from the Mapping Editor toolbar. To do so you first need to select an object icon in the Source and Target panes. If the selected source object icon is ambiguous (a folder for example), you are prompted to select one from a selection list.

For example, you define a mapping between table TOTAL_SALES in Model_1 and table EUROPEAN_SALES in Model_2 and ASIAN_SALES in Model_3. Each table has a column called TOTAL AMOUNT. You can define column TOTAL AMOUNT in TOTAL_SALES as the sum of total amounts in EUROPEAN_SALES and ASIAN_SALES:

To create a mapping using the Create Mapping tool from the mapping Editor toolbar:

Select an object icon in the Source pane and select an object icon in the Target pane.

Click the Create Mapping tool in the Target pane toolbar.

A link is automatically created between both objects to materialize the mapping and a small symbol is displayed on the source and target object icons. The mapping details display in the Mappings pane.