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 .
- 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.