Use the Table Map Editor to add a column map to a pair
of mapped tables.
To add a column map to a table map:
- Expand a folder in the Directory Explorer that contains
the table map, expand the Table Maps node,
and double-click the table map. The Table Map Editor
opens.
- Select the Table map tab.
- In the Table map area, select the
row that contains the tables for the column map.
- Click Add Column Map. The New Column Map window opens with a list of column
maps that contain the selected tables.
- Select a column map or select Create a new column
map to create a column map based on the selected tables.
Click OK.
- If you choose to create a new column map, the Column
Map Editor opens and is populated with the columns from the selected
tables.
- Edit and save the new column map.
- Save the table map.