In this exercise you will create an access definition.
Use access definitions to specify the tables, relationship traversal,
and selection criteria for the data you want to process.
Before creating an access definition, a data store alias
must exist for the database that contains the start table.
To create an access definition:
- Expand the Tutorial folder in the Directory Explorer, right-click Access
Definitions, and click . The New Access
Definition wizard opens.
- On the Enter Access Definition Name page, enter SAMPLE.AD.
Click Next.
- On the Select a Data Store Alias page, select the data
store alias that contains the Optim™ sample
data. Click Next.
- On the Select a Start Table page, do the following steps:
- In the Table Search Pattern field,
enter the following search pattern: SCHEMA.OPTIM_CUSTOMERS,
where SCHEMA is the schema that contains the Optim sample data. For example: SAMPLE.OPTIM_CUSTOMERS.
- Click Display Tables. The table list displays tables that match the pattern.
- Select the OPTIM_CUSTOMERS table.
- Click Next.
- On the Specify a Table Selection Method page, click Find
related tables. Click Next.
- On the Display and Select Related Tables page, do the following
steps:
- Click Display Tables. The table list displays tables related to OPTIM_CUSTOMERS.
- Click Select All.
- Click Finish.
The new access definition is displayed in the Access Definition
Editor.