To create a Column Map:
- In the main window, select Column
Map from the Definitions menu to
open the Column Map Editorand last edited Column
Map.
- Your next step depends on your purpose:
- To create a new Column Map, select New from
the File menu in the Column Map Editor to open
the New Column Map dialog. Specify the source/destination
tables OR Source1/Source 2 tables, and click OK to
open the Column Map Editor.
- To create a new Column Map modeled on an existing
one, open the desired Column Map and select Save As from
the File menu in the Column Map Editor.
- To create and store a copy of the active Column
Map and continue editing, select Save Copy As from
the File menu in the Column Map Editor.
Note: Pseudocolumns for attached files are automatically displayed
in a Compare Column Map when Source 2 includes attached files. If
Source 1 pseudocolumns are not displayed automatically, you can select
them as Source 1 columns.
These steps are the minimum
required to create a Column Map. The steps to edit a new Column Map
or existing Column Map are similar. See Using the Editor for details.
In addition,
you can open the Column Map Editor from the Tools menu
in the Convert Request Editor, Insert Request Editor, or
Load Request Editor. For details, refer to the appropriate
chapter in the corresponding user manual.