After selecting the tables and specifying selection criteria for the data, you must define the traversal path. That is, you select the relationships to be used and the direction in which the relationships are traversed—from parent to child, from child to parent, or in both directions—during the Extract Process.
The traversal path determines the
sequence in which
Move selects data from tables referenced in the Access Definition.
Consider the database structure of the tables you selected for extracting:
In this diagram, the relationships between tables are represented by three-character codes consisting of the letter "R", the first letter of the parent table, and the first letter of the child table.
CUSTOMERS is the Start Table, because you want to extract a subset of CUSTOMER data. Based on the relationships between each pair of tables:
To obtain the desired set of data for this scenario, you will include relationships RCO and ROD in the Extract Process and specify the direction in which Move traverses them.
Use the options on the Relationships tab to define the traversal path for selecting data from the tables referenced in the Access Definition. All relationships between pairs of tables in the Table List are displayed. The parent table and the corresponding child table in each relationship is provided.
Each listed relationship has a status, which indicates:
(After you have viewed the relationship, the status is no longer New and is shown as blank the next time you display the Relationships tab.)
When you run the Extract Process, a warning message advises you of any new relationships. Although you may proceed despite the warning, it may be prudent to review the relationship usage list.
The Use new relationships check box is selected by default to include all relationships with a New status in the Extract Process. If you clear this check box, you must manually select new relationships to include them in an Extract Process. Clearing the check box ensures that a completed Access Definition is not affected by the addition of a new relationship.
The Select column determines whether a relationship is used in the Extract Process.
For this scenario, verify that check boxes for relationships RCO and ROD are selected.
You can use the Options check boxes to extend the traversal path:
For this scenario, only Option (1) is selected because no tables will be traversed from child to parent.