Use the Table Map Editor to edit target data stores, schemas,
and tables for source tables in a table map.
Before editing table map target data, a default target
data store alias must exist for the target data.
To edit target data in 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 source table.
- To define a target data store alias, click the Target
Data Store cell and enter the name of a target data store
alias.
- To define a target schema, click the Target
Schema cell and select the target schema from the list.
- To define a target table, use one of the following options:
- Enter a name in a Target Table cell.
- Click Select a Target Table to open the
Select a Target Table window and select a table.
- Click Auto Map to use the source table
name for a selected table.
- Click Auto Map All to use the source table
names for all target tables.
- Save the table map.