In an Insert Process, you use a Table Map to direct the
placement of data. A Table Map matches the source tables in the Extract
File to the destination tables in the database.
To display the Table Map Editor,
click from the Insert Request Editor.
Note: If the Always View Table Map option is
selected in the Insert Request Editor, the Table
Map Editor automatically displays when you run the process.
This option allows you to verify the Table Map.
- Source
- Displays the Extract File and Qualifier associated
with the source data.
- Destination
- Enter the Qualifier for the
destination data. For this scenario, enter the same Destination Qualifier
as the Source Qualifier.
- Description
- You can enter an optional description of the Table
Map.
- Column Map ID
- Specify a default Qualifier for Column Maps used
in the Table Map. Use a Column Map to correlate source and destination
columns and to transform source data before inserting it. For this
scenario, leave the box blank because Column Maps are not used.
- Server Name
- Displays the name of an Optim™ Server or Local, to indicate where processing
will take place
- Source Table
- Lists the source table names in the Extract File.
- Destination Table
- Lists
the destination table names. When you create a new Table Map, the
destination table names are the same as the source table names by
default. You can modify the destination table names. For this scenario,
prefix the destination table names with Test_ to
create new tables for the test database.
- Type
- Identifies the type of object in Destination
Table. For this scenario, Type will
display Table for each destination table until you change the table
names. After you change the names, Type will
display Unknown for each new table name.

Click from the Table
Map Editor to return to the Insert Request Editor.
For further information about Table Maps, see the Common Elements Manual.