New Table Map Dialog

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.

new table map dialog, explained below

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.