Adding a Source Mapping via Source Mapping tab

1. To add a source mapping to an entity, right-click on the header part of the entity displayed in the diagram and then choose Properties.

REPLACE WITH THIS IMAGE: Images/Entities/Adding a Source Mapping via.png

1. On the Properties window, click the Source mappings tab.
2. In the Source mapping sets pane, click REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png to add a source mapping set. The source mapping sets enables you to map Multi Source objects in WhereScape RED.
   1. Enter a Name for the source mapping set in the Add source mapping set dialog.
   2. Click OK.
3. Click the REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png Add source entities button from the toolbar to open the Add source mapping dialog.

REPLACE WITH THIS IMAGE: Images/Entities/Adding a Source Mapping via_2.png

1. Select the source entities or host files that you want to map to the selected target entity and then click OK.

   Note
   You can use the keyboard Ctrl or Shift key to select multiple items from the source tree.

2. REPLACE WITH THIS IMAGE: Images/Entities/Adding a Source Mapping via_3.png
3. The selected source entities are displayed in the Source mappings tab. The columns from the source entities that exists in the target entity are automatically mapped. 

REPLACE WITH THIS IMAGE: Images/Entities/Adding a Source Mapping via_1.png

1. You can view the source mapping details of a source table by clicking the line that connects it to the target table from the diagram. The details are displayed in the right pane.

REPLACE WITH THIS IMAGE: Images/Entities/Adding a Source Mapping via_5.png

1. In the same manner, you can view the source mapping details of a source column by clicking the line that connects it to the target column.

REPLACE WITH THIS IMAGE: Images/Entities/Adding a Source Mapping via_6.png

1. To map the additional source columns that does not exist in target entity, click the source column you want to map and drag the line that appears to the Add attribute row in the target entity.

REPLACE WITH THIS IMAGE: Images/Entities/Adding a Source Mapping via_7.png

1. The new source column is added and mapped to the target entity.

REPLACE WITH THIS IMAGE: Images/Entities/Adding a Source Mapping via_8.png

1. Click OK.