When you create a Table Map, the New Table Map dialog and
the Table Map Editor open at the same time. After selecting the appropriate
Source Table options, select OK to return to
the Table Map Editor.
Server Name
If
the optional Optim™ Server component
is installed on your network, click the down arrow to select Local if
the file is accessed from the client workstation, or name of the server
on which the file resides.
Validation Rules
If
the Table Map is to be used in a Convert, Create, Insert, or Load
Process, select Move/Archive validation rules.
Select Compare for use in a Compare Process.
The group box labels vary according to your selection. In the previous
illustration, Move/Archive validation rules are selected and the group
boxes are labeled Source and Destination. For Compare
validation rules, the labels are Source 1 and Source 2.
Source or Source 1
When
you create a new Table Map, you must indicate the source for the objects
you want to map. You can specify the source as an Extract or Archive
File, or as an Access Definition:
- File
- Select this option to map source tables from an
Extract or Archive File.
- Name
- Directory path and name of the file. If a directory
path is not specified, the data directory path specified in Personal
Options is used.
- To select from a list of recently used file names,
click the down arrow.
- To select from a directory, click the browse button.
- Access Definition
- Select this option to map source objects referenced
by an Access Definition.
- Name
- Fully qualified name of the Access Definition. If
a directory path is not specified, the data directory path specified
in Personal Options is used by default.
- To select from a list of recently used Access Definitions,
click the down arrow.
- To select from a list of available definitions,
click the browse button.
Destination or Source 2
For Move/Archive validation rules, the destination can
only be Database Tables. For Compare validation rules, all Source
2 options apply. Select:
- File
- Select this option to map to source tables from
an Extract or Archive File. This option is enabled if Compare validation
rules are selected.
- Name
- Directory path and name of the file. If a directory
path is not specified, the data directory path specified in Personal
Options is used.
- To select from a list of recently used file names,
click the down arrow.
- To select from a directory, click the browse button.
- Access Definition
- Select this option to map to source objects referenced
by an Access Definition. This option is enabled if Compare validation
rules are selected.
- Name
- Fully qualified name of the Access Definition. If
a directory path is not specified, the data directory path specified
in Personal Options is used by default.
- To select from a list of recently used Access Definitions,
click the down arrow.
- To select from a list of available definitions,
click the browse button.
- Database Tables
- Select this option to map destination or source
objects in a database.