Review the Access Definition

Consider the steps performed to extract the data based on the specified parameters, selected relationships and specifications for Options (1) and (2). The following simplified data is displayed for each table to aid in the explanation.

Steps:
  1. Every tenth CUSTOMERS row is extracted based on the sampling factor.
  2. The ORDERS rows for these CUSTOMERS rows are extracted because of the parent to child traversal of relationship RCO.
    CUSTOMERS to ORDERS steps
  3. The DETAILS that are related to the extracted ORDERS, ORD4 and ORD5, are extracted by traversing the relationship ROD from parent to child.
  4. Lastly, all rows in the ITEMS table are extracted because the table is designated as a Reference Table.ORDERS to DETAILS steps

Optim™ provides tools in the Access Definition Editor for you to evaluate the set of data to be extracted prior to performing the Extract Process. After specifying the list of tables, selection criteria, Extract parameters and relationships, evaluate the data to extract using the Tools menu in the Access Definition Editor.

Show Steps Tool

Click Tools > Show Steps to display a narrative that describes the traversal path of the Extract Request. Verify the traversal path to ensure that you extract the desired set of data.

The traversal path of the Extract Request shown on Show Steps

Indent Tool

Click Tools > Indent from the Access Definition Editor to display the Indented Table Display dialog, which shows the list of tables formatted to show relationships. The related tables are displayed with a prefix of C or P to indicate Child table or Parent table, respectively.

Indented Table Display dialog

Click File > Update and Return from the Access Definition Editor to update the Access Definition and return to the Extract Request Editor.