Create a Table Map

This section explains how to create a Table Map from the main window or the Table Map Editor.

From the Main Window for Move or Archive

To create a Table Map for Move or Archive:

  1. In the main window, select New from the File menu.
  2. Select Table Map from the Definitions submenu to open the New Table Map dialog.
  3. For Validation Rules, select Move/Archive.
  4. 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.
  5. Click OK to open the Table Map Editor.
  6. Specify the Default Qualifier in the Destination box for the tables you want to map.
  7. Modify the Destination Table names, as needed to map the data to the destination tables.
  8. In the Table Map Editor, select Save from the File menu to open the Save the Table Map dialog.
  9. In the Pattern box, specify a unique Table Map name and then click Save

From the Main Window for Compare

To create a Table Map for Compare:

  1. In the main window, select New from the File menu.
  2. Select Table Map from the Definitions submenu to open the New Table Map dialog.
  3. For Validation Rules, select Compare.
  4. Specify Source 1 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.
  5. Specify Source 2 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.
  6. Click OK to open the Table Map Editor.
  7. If you select Database Tables for Source 2, specify the Default Qualifier for the Source 2 tables you want to map.
  8. Modify the Source 2 Table names, as needed, to map the data.
  9. In the Table Map Editor, select Save from the File menu to open the Save the Table Map dialog.
  10. In the Pattern box, specify a unique Table Map name and then click Save.

From the Table Map Editor

To create a Table Map:

  1. In the main window, select Table Map from the Definitions menu to open the Table Map Editor and last edited Table Map.
  2. Your next step depends on your purpose:
    • To create a new Table Map, select New from the File menu in the Table Map Editor to open the New Table Map dialog. Specify the source/destination tables OR Source 1/Source 2 tables, and click OK to open the Table Map Editor.
    • To create a new Table Map modeled on an existing one, open the desired Table Map and select Save As from the File menu in the Table Map Editor.
    • To create and store a copy of the active Table Map and continue editing, select Save Copy As from the File menu in the Table Map Editor.

These steps are the minimum required to create a Table Map. Because the options to create and modify Table Maps are similar, see Using the Editor for details.

Note: In addition, you can open the Table Map Editor from the Tools menu in the Convert Request Editor, Insert Request Editor, or Load Request Editor. For details, see the appropriate chapter in the corresponding user manual.