You can include Column Maps in a Table Map to map the columns in source and destination tables or to compare the columns in Source 1 and Source 2 tables. By default, columns that have the same names and matching attributes are mapped to each other.
Use Column Maps to accomplish the following:
Specify the name of the Column Map in a Table Map Editor in the following ways:
When you specify the name of an existing Column Map in the Column Map or “LOCAL” grid column, you can use the Column Map as it is or you can edit the Column Map. If changes were made to the database tables since the last time the Column Map was used, the specifications may no longer be valid.
To view or edit the Column Map, right-click and select Open Column Map from the shortcut menu to display the Column Map Editor. For complete details on how to create and edit Column Maps, see Column Maps.
Use the Column Map or “LOCAL” grid column to specify a new Local or Named Column Map in a Table Map:
If you want to use a Local Column Map with other Table Maps, select Save Copy As from the File menu. For complete details about using the Column Map Editor, see Column Maps.
The Column Map Status changes to Unknown if you specify local or if you specify a Column Map name that does not exist. A message is displayed at the bottom of the editor to indicate that you must define the Column Map before you can save the Table Map.
You can select an existing Column Map from a list. To display a list of Column Map names, right-click and select List Column Maps from the shortcut menu.
The List Column Maps dialog shows all available Column Maps, whether or not the table names match names in the Table Map Editor. (You can use a Column Map defined for tables with different names as long as one or more column names match.)
Use a Pattern to limit the list of Column Maps in the List Column Maps dialog. After you specify a pattern, click Refresh to redisplay the list based on your criteria. See Use a Pattern for more information.
Populate automatically inserts the names of Column Maps into the Column Map or “LOCAL” grid column in the Table Map Editor. You can specify criteria for the Column Map names.
In the Table Map Editor, select Populate... from the Tools menu (or right-click and select Populate... from the shortcut menu) to open the Populate Column Maps dialog. Specify the criteria for selecting Column Maps.
A two-part qualifier for the Column Map names. You can use SQL LIKE syntax to specify the qualifier and limit the candidate list of Column Maps. Initially, %.% (the default) to search all Column Maps is displayed.
The method Populate uses to insert Column Map names in the Column Map or “LOCAL” grid cells in the Table Map Editor. Select one of the following:
Indicate how Populate matches Column Maps to the Table Map. Select one of the following:
Select this check box to ensure that Populate inserts fully qualified names of Column Maps into the Table Map. This option is useful when you do not specify a default Column Map ID in the Table Map Editor or when the default does not contain the appropriate Creator ID.
Populate scans each pair of source and destination tables in the Table Map Editor to generate a list of Column Maps that match your criteria.
The method for populating the Column Map or “LOCAL” grid column is determined by your Merge Type selection. The extent of the search is determined by your Match Type selection.
When Populate finds several matches for a pair of tables, the Select One Column Map dialog lists the candidate Column Maps. The full matches are listed first, followed by table matches. The names of the two tables that are being processed are displayed in the message box.
The Column Map or “LOCAL” grid column of the Table Map Editor lists the selected Column Maps and any inserted automatically.
Field name | Description | |
---|---|---|
Matching | SQL LIKE syntax you specified as the Matching criteria in the Populate Column Maps dialog. | |
Map ID | Qualifier of the Column Map name that matches your criteria. | |
Map Name | Name of the Column Map that matches your criteria. | |
Source | Type of
match between the source table in the Column Map and the source table
in the Table Map.
|
|
Destination | Type of
match between the destination table in the Column Map and the destination
table in the Table Map.
|