You can find relationships between source and target schemas
by using the discover function in the mapping editor.
Before you begin
The Mapping editor must be open and contain
source and target schemas.
Procedure
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.