A Table Map provides specifications needed to direct data from source tables to destination tables, match pairs of tables for a Compare Process, or exclude tables from processing. A Table Map may also reference a Column Map for a pair of tables in the Table Map to pair columns with different names or attributes, generate column data, or eliminate individual columns from processing.
For more information about Column Maps, see Column Maps.
A Table Map is required for an Insert, Load, Restore, Convert, or multi-table Compare Process. You can define a Table Map while setting up a process or independently, by selecting a menu option. Except in a Batch Utility Restore Process, however, an independently created Table Map is not directly referenced by the process; you must use the APPLY command in order to use an independently created Table Map during processing. For more information about the APPLY command, see Apply a Table Map .
Whether a Table Map is defined independently or in setting up a process, the steps are generally the same. This section describes how to define a Table Map through a menu option, and mentions any exceptions for Compare processes. Additional information about Table Maps defined within a process is provided in the discussion of each process in the appropriate User Manual.