Finding relationships between sources and targets

You can find relationships between source and target schemas by using the discover function in the mapping editor.
Prerequisite:

The Mapping editor must be open and contain source and target schemas.

To find relationships:

  1. Right-click in the mapping editor. You can run the discover function from any pane if a source or a target is selected. The scope of the discover function depends on the pane that currently has focus.
  2. Click Find Same Name . Specify Scope to Discover Relationships window opens.
  3. Optional: On the Specify Scope to Discover Relationships window, select the scope of the discover function.
    1. In the Source field, specify the database, schemas, tables, or columns from the data source to include or exclude in the attempt to find relationships.
    2. In the Target field, specify the database, schemas, tables, or columns from the data target to include or exclude in the attempt to find relationships.
    3. Select the Do not show this window again while looking for relationships check box to exclude the Specify Scope to Discover Relationships window. If you select the check box, the scoping is defined automatically.
    4. Click Finish to find relationships between the source and the target elements.

The results are represented as discovered mappings inside the mapping editor in the center pane. They are also visible in the outline view.


Feedback