In this exercise, you will create a table map. Use a table
map to define specifications for correlating source and destination
tables of compatible data. You can map tables that have different
names, modify table names, exclude tables from a process, or include
column maps for greater control over the data.
- Expand the Tutorial folder in the Directory Explorer, right-click Table
Maps and click . The New Table Map wizard opens.
- On the Enter Table Map Name page, enter SAMPLE.TMAP in
the Name field. Click Next.
- On the Choose a Source File page, click Browse
to an Optim file.
- In the Browse to an Optim file area,
click Browse. The Please
select an Optim™ file window
opens.
- Browse to the location of the SAMPLE_EXT file created in
the Extracting data with Optim Designer tutorial.
- Select the file and click Open. The file displays in the Optim file name field.
- Click Next.
The new table map is displayed in the Table Map Editor.
You must use the editor to define target data stores and
schemas before saving the table map.