Edit the Table Map

You will use the same Table Map specifications from Scenario 1, but the Scenario 2 Table Map will include a Column Map for the ORDERS table.

To display the Table Map Editor, click Tools > Edit Table Map.

Destination
For this scenario, verify the Qualifier matches the DB Alias and Creator ID of the test database tables created in Scenario 1.
Description
Enter a description of the Table Map.
Column Map ID
For this scenario, leave the Column Map ID box blank. A Column Map ID is only required when the name of one or more specified Column Maps is not fully qualified.
Destination Table Names
For this scenario, verify the destination table names match those created in Scenario 1.
Column Map or “LOCAL”
For this scenario, specify a local Column Map. Type the word LOCAL in the Column Map or LOCAL column for the ORDERS table. When you click outside the grid cell, the Status column changes from Unused to Unknown. The status is Unknown until you define the Column Map in the next step.
Table Map Editor