Map

Relationship Fields

To access this page in dspMigrate:

1. Click Map in the Context bar.
2. Click the Targets icon on the Process Area Launch page.
3. Click the Sources icon for a Target in the Parent pane.
4. Click the Update Row Sources icon for a Target Source in the Child pane.
5. Click the Secondary Source icon for a Target Source (Add Row) in the Parent pane.
6. Click the Relationships icon for the Target Source (Update Row) in the Child pane.
7. Click the Fields icon for the Relationship Join in the Parent pane.

Field	Description
PRIORITY	Displays the order the selected join will be built.
TARGET RELATIONSHIP ID	Displays the name of the relationship, for example: Join MARA to MARC (Material to Plants).
JOIN TYPE	Displays INNER JOIN, the only option available.
LEFT TABLE	Displays the name of the table on the left of the join. NOTE: This table must exist in the Object’s database where the join will be generated and executed.
LEFT FIELD	Displays the name of the field in the left table for the join. NOTE: This field must exist in the Object’s database where the join will be generated and executed.
OPERATOR	Displays the operator used in the join. Equals is the only operator available.
RIGHT TABLE	Displays the name of the table on the right of the join.
RIGHT FIELD	Displays the name of the field in the table on the right of the join. NOTE: This field must exist in the Object’s database where the join will be generated and executed.