Editing target data in a table map

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:

  1. 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.
  2. Select the Table map tab.
  3. In the Table map area, select the row that contains the source table.
  4. To define a target data store alias, click the Target Data Store cell and enter the name of a target data store alias.
  5. To define a target schema, click the Target Schema cell and select the target schema from the list.
  6. 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.
  7. Save the table map.


Feedback