You can find relationships between source and target schemas by
using the discover function in the mapping editor.
Before you begin
Prerequisite:The Mapping editor must be open and contain
source and target schemas.
About this task
To find relationships:
- 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.
- Click and select one of the following menu options:
Menu option |
Description |
Find Best Fit |
Find
the most satisfactory match that exists among all of the elements in the model.
This method finds at most one match for one target and one source that you
select. You can run the discover function from this choice. |
Find Similar |
Find
the top five matches for each selected element in the target. You can run
the discover function from this choice. |
Enterprise Naming Standard |
Specify one or more naming standards that you want to associate with
schemas. |
Advanced Configuration |
This option is for advanced users. You can use the discover function
with no further configuration. Use this option if you want to use more than
the default configurations. You can specify which algorithm to use, configure
the data sampling, and some other advanced options. |
- Optional: On the Specify Scope to Discover
Relationships page, select the scope of the discover function.
- 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.
- 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.
- 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.
- Click Finish to find relationships between
the source and the target elements.
Results
The results are represented as discovered mappings inside the mapping
editor in the center pane. They are also visible in the outline view.