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:
- 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.
- Select the Table map tab.
- In the Data store alias and schema map area,
select the row that contains the source data store.
- Click the Target Data Store Alias cell
and select the data store alias that contains the Optim™ sample data.
- Click the Target Schema cell and
select the schema that contains the Optim sample
data.
- From the main menu, click 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.