A Table Map identifies and matches two sets of tables.
Use a Table Map to:
Depending on the process for which you are using a Table Map, the two sets of tables are referred to as Source Tables and Destination Tables, or Source 1 Tables and Source 2 Tables:
Table Maps are stored in the Optim™ Directory or embedded in a process request.
As an option, you can use a Column Map for any pair of tables in a Table Map. Column Maps identify and match columns in a pair of tables. A Column Map must be used when column names or attributes are dissimilar or data transformations are needed. For complete details on defining and editing Column Maps, see Column Maps.
The fully qualified name of a Table Map is in the form: identifier.name.
It is helpful to use a logical set of naming conventions to identify the use for each and to organize definitions for easy access.
This section explains how to create and maintain Table Maps, including how to: