Creating a table map

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.

To create a table map:

  1. Expand the Tutorial folder in the Directory Explorer, right-click Table Maps and click New Table Map. The New Table Map wizard opens.
  2. On the Enter Table Map Name page, enter SAMPLE.TMAP in the Name field. Click Next.
  3. On the Choose a Source File page, click Browse to an Optim file.
  4. In the Browse to an Optim file area, click Browse. The Please select an Optim™ file window opens.
  5. Browse to the location of the SAMPLE_EXT file created in the Extracting data with Optim Designer tutorial.
  6. Select the file and click Open. The file displays in the Optim file name field.
  7. 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.



Feedback