When you choose to create a new Column Map from the Definitions submenu, the Column Map Editor opens, along with the New Column Map dialog. You can also open the New Column Map dialog by selecting New from the File menu in the Column Map Editor.
(For a description of the Definitions submenu, see From the Main Window: Move or Archive.)
After you specify the appropriate parameters in the New Column Map dialog, the Column Map Editor is displayed.If the optional Optim™ Server is installed on your network, and the table containing the source column is in an Extract or Archive File, click the down arrow to select Local if the file is accessed from the client workstation, or the Server on which the file resides.
If the Column Map is to be used in a Convert, Insert, or Restore 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.
When you create a new Column Map, you must indicate the source for the columns you want to map. You can specify the source as a table in an Extract or Archive File or the database:
For Move/Archive validation rules, the destination can only be Database Table. For Compare validation rules, all Source 2 options apply.
Enter the appropriate parameters, provide entries to define the source and destination tables OR Source 1 and Source 2 tables, and select OK to open the Column Map Editor.