Do the following to create a Column Map from the Column
Map Editor:
- In the main window, select Column
Map from the Definitions menu to
open the Column Map Editor and the 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 that
is modeled on an existing one, open the appropriate 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
steps that are required to create a Column Map. The steps to edit
a new Column Map or existing Column Map are similar. See Using the Column Map 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, see the appropriate chapter
in the corresponding user manual.