Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  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.

...

  1. Image Added
  2. On the the Properties window, click the Source mappings tab.
  3. In the the Source mapping sets pane, click REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png Image Added 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.
  4. Click the REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png Image Added Add source entities button from the toolbar to open the Add source mapping dialog.

...

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

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

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

...


  1. Image Added
  2. 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.

...

  1. Image Added
  2. 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.

...

  1. Image Added
  2. 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.

...

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

...

  1. Image Added
  2. Click OK.