In the Table Map Editor, you can create, modify, or delete Table Maps stored in the Optim™ Directory or defined within an Action Request.
You can edit a Table Map in any or all of the following ways:
When you create a new Table Map, the source and destination table grid cells in the Table Map Editor are populated automatically, according to options selected on the New Table Map dialog (see Create a Table Map). You can edit the destination table names and you can create or specify Column Maps, as needed.
Qualifier provides the default DB Alias and Creator ID for source tables in the Extract or Archive File or referenced in the Access Definition that are not fully qualified.
Enter the default qualifier (dbalias.creatorid) for the destination table(s) listed in the Table Map. Click the down arrow or the browse button to select from a list.
The Column Map Identifier qualifies any Column Maps specified by the base name only. If you specify a fully qualified Column Map name in the Column Map or “LOCAL” grid column, the Column Map ID is ignored. When you create a new Table Map, the Column Map ID is initially blank.
Tabs on the Table Map Editor correspond to the types of objects in the Extract or Archive File or referenced in the Access Definition. If an object type is not in the source, the tab is hidden. Only the Tables tab is enabled when Compare validation rules are used.
The effect of this option depends upon the method used to open the Table Map Editor:
In addition to the standard commands on the File, Edit, and Tools menus, you can select the following commands from the Tools menu:
Select the Tables tab to review mapped database tables or views. The source must be a table, but the destination can be a table or a view.
For information on referencing Column Maps in a Table Map, see Specify Column Maps in a Table Map.
Select the Defaults tab to review mapped source and destination defaults.
Select the Functions tab to review mapped source and destination database functions.
Select the Packages tab to review mapped source and destination database packages.
Select the Procedures tab to review mapped source and destination database procedures.
Select the Rules tab to review mapped source and destination rules.
Select the Sequences tab to review mapped source and destination sequences.
Select the User Defined Types tab to review mapped source and destination user defined types (UDTs).
Select the Views tab to review mapped source and destination database views. The source and the destination must be a view. (Note that on the Tables tab, the source must be a table, and the destination can be a table or a view.)
Select the Assemblies tab to review mapped source and destination database assemblies.
Select the Partition Functions tab to review mapped source and destination database partition functions.
Select the Partition Schemes tab to review mapped source and destination database partition schemes.