Editing a table map

In this exercise, you will use the Table Map Editor to define target data stores and schemas for source tables in a table map.

To edit target data in a table map:

  1. Expand the Tutorial folder in the Directory Explorer, expand the Table Maps node, and double-click the SAMPLE.TMAP table map. The Table Map Editor opens.
  2. Select the Table map tab.
  3. In the Data store alias and schema map area, select the row that contains the source data store.
  4. Click the Target Data Store Alias cell and select the data store alias that contains the Optim™ sample data.
  5. Click the Target Schema cell and select the schema that contains the Optim sample data.
  6. From the main menu, click File > Save to save the table map.

The table map uses the same source and target tables in order to mask source data and maintain the same schema and data store alias.



Feedback