To create a new local or global mapping group:
The Create New Mapping Group or New Global Mapping Group window opens.
To select a list of tables you can use Shift-click on the first and last table in the set, use Control-click to select multiple individual tables, or use the + button in the source and target mapping editor panes to manually add schema and table names. In the column mapping editor the equivalent + button allows you to add columns manually.
For example, if Table EMP1
in Source is to be mapped with EMP_BACK1
in Target, drag EMP1
from Source and drop it on EMP_BACK1
at Target. EMP_BACK1
appears as a Mapped From table for EMP1
indicating a successful mapping.
You can also use the keyboard to perform the same action. When a source or target schema does not have a reference to any specific Resources Navigator schema and the name matches a particular database name in the Resources Navigator, a confirmation dialog is displayed to associate the resource. You can select Yes to complete the mapping.
If you select a table as target in the Mapping Editor which is not mapped, the Properties Inspector displays a Mapped From text box. You can enter the source table name which will be validated against a valid source table references and can be mapped to target table if the source table is valid.