To map a new table an EIM interface table using the EIM Table Mapping Wizard
1. Lock the project.
2. Select Table object type in the Object Explorer.
3. Select an entry in the Object List Editor. Choose from the list a base table that will be mapped to an EIM Table. It will be the primary table into which data from the new IF table will be imported. This wizard is only available to tables of type Data (Public) and Data (Intersection), and Data (Extension), and Data (Extension-Siebel).
4. Right-click and select EIM Mapping Table from the menu. The Interface Mapping dialog box is displayed with the Base Table name field populated with the selection made in the Object List Editor.
5. In the "Edit the Column name prefix" field, enter a distinguishing prefix, similar to "CON" for contact or "ACCT" for account. This prefix will be pre-appended to specified EIM Interface Table Columns related to the Target Table.
6. In the "Select an interface table" field, select from the pick list. The pick list for selecting the EIM Interface Table that will be mapped is constrained to show the following:
a. Those standard interface tables that are mapped to tables to which the new custom table has a foreign key.
The list is sorted by EIM table name. In the list candidate interface tables are displayed.
7. Click Next on the Interface Table Mapping dialog box. The Summary dialog box appears with a summary of the choices made.
8. Click Finish on the Summary dialog box to accept the choices made and generate the EIM Interface Table object.
Based on this information, the wizard creates new EIM table mapping objects and adds several child objects to an existing EIM interface table object:
- EIM Interface Table Column
- EIM Table Mapping
- Attribute Mapping
- EIM Explicit Primary Mapping
- Foreign Key Mapping
- Foreign Key Mapping Column