Consider the steps performed to extract the data based
on the selection criteria, selected relationships, and specifications
for Options (1) and (2). The following simplified data is displayed
for each table to aid in the explanation.
- Steps:
- The rows from the Start Table, ITEMS, are selected
by Point and Shoot to extract specific items. The specific ITEMS in
this example are CH1 and CH4.
- The DETAILS rows for these
ITEMS rows are extracted because the DETAILS are children of the previously
selected ITEMS using the relationship RID. The extracted DETAILS rows
are DTL1, DTL5, and DTL8.
- The ORDERS related to the extracted DETAILS rows, ORD1, ORD4 and
ORD5, are extracted by traversing the relationship ROD from child
to parent.
- The CUSTOMERS related to the ORDERS are extracted by traversing
the relationship RCO from child to parent.
- The additional DETAILS for the extracted ORDERS are extracted
by traversing the relationship ROD from parent to child because Option
(2) is selected. Additional DETAILS rows for ORDERS rows ORD4 and
ORD5 are extracted.
- The ITEMS rows related to the additional extracted DETAILS rows
are extracted by traversing the relationship RID from child to parent.
The rows for CH2 and CH3 are extracted from the ITEMS table for the
additional DETAILS rows.
Show Steps
Click to display a narrative that describes the traversal
path of the Extract Request.
Click to return to the Access Definition Editor.
Click from the Access Definition
Editor to update the Access Definition and return to the Extract
Request Editor.