Use the Tables tab of the Access Definition Editor to specify the list of tables to include in the Extract Process.
The Default Qualifier saves time when you enter table names in the grid, or Table List. A fully qualified table name has three parts: dbalias.creatorid.tablename. The Default Qualifier serves as the prefix for names in the Table List that are not fully qualified.
The Default Qualifier can be either dbalias or dbalias.creatorid. Generally, use a Default Qualifier that applies to most or all tables in the Table List. For this scenario, enter the dbalias and creatorid that correspond to the Optim™ sample database tables.
Each Extract Process begins with a Start Table, the table from which data is first extracted, and proceeds to obtain related data from the remaining tables in the Table List. Move automatically places the Start Table in the first line of the Table List. If you do not specify a Start Table, the first name entered in the Table List is the assumed Start Table.
For this scenario, type CUSTOMERS in the Start Table box. Using this Start Table, you can create a subset of data based on a sampling of customers.
The Table List references tables from which data is extracted. When you add a table name to the Table List, Move automatically displays the type of object referenced by the table name and the name of the DBMS for the table.
You can use two methods to add table names to the list. One method is to type names under the Table/View heading. An easier method, however, may be to let Move find the tables that contain related data, using the Select Table(s) dialog.
For this scenario, use the Select Table(s) dialog to display a listing of tables related to the Start Table. You can review the list and select tables you want to include in the Extract Process.
To display the Select Table(s) dialog, right-click the CUSTOMERS table name in the Table List and click Add Tables in the shortcut menu. The dialog provides a list of tables, based on the Default Qualifier.
For this scenario, limit the list to tables related to the CUSTOMERS table, and select specific tables from the list.
The Table List in the Access Definition Editor is now populated with the Start Table, CUSTOMERS, and all the tables related to the CUSTOMERS table.