Creating a table map

Use the Table Map Editor to create a Table Map.

When you create a new Table Map, the source and destination table grid cells in the Table Map Editor are populated automatically, according to options selected on the New Table Map dialog. You can edit the destination table names and you can create or specify Column Maps, as needed.

  1. In the main window, select Table Map from the Definitions menu. The New Table Map dialog opens.
  2. From the Validation Rules area, select Move/Archive.
  3. Specify the source for the tables you want to map:
    • If you select the File option, supply the file name.
    • If you select the Access Definition option, supply the name of the Access Definition.
  4. Click OK. the Table Map Editor opens.
  5. Specify the Default Qualifier in the Destination box for the tables you want to map.
  6. Modify the Destination Table names, as needed to map the data to the destination tables.
  7. In the Table Map Editor, select Save from the File menu to open the Save the Table Map dialog.
  8. In the Pattern box, specify a unique Table Map name and then click Save.