Merge Table Maps

Use the Merge command to overlay all or part of the Table Map in the Table Map Editor with the specifications from another Table Map. If the source table names in the two Table Maps match, Merge copies the associated destination table names and Column Maps from the merge Table Map to the Table Map in the Table Map Editor.

To merge Table Maps:

  1. In the Table Map Editor, open a Table Map.
  2. Select Merge from the Tools menu to open the Merge a Table Map dialog.
  3. Select the Table Map you want to merge.
  4. Specify a Target: click Tables, Column Map, or Both.
  5. Select a Merge Type: click Replace, Clear, or Add.
  6. Click Open to merge Table Maps and return to the Table Map Editor.

It is useful to merge Table Maps when you want to create:

For example, suppose that you use a common pool of tables for many different process requests. To make processing easier, you create a master Table Map that defines the default mapping for these tables. With a master Table Map in place, you can merge the master Table Map into a specific Table Map for any process request.

Even though two process requests involve two different sets of tables, which may or may not overlap, you can merge the same master Table Map to define Table Maps for both. This feature ensures consistent mapping with minimum effort. After the merge, you can edit the Table Map in the Table Map Editor.