Edit the Table Map

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 Tools > Edit Table Map 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.
Table Map Editor

Click File > Update and Return from the Table Map Editor to return to the Insert Request Editor.

For further information about Table Maps, see the Common Elements Manual.