In the Tables list, locate the table that must reference an EIM Table.

This table is the primary table into which EIM imports data from the predefined interface table.

Right-click the record, and then choose EIM Table Mapping.

Siebel Tools displays the Interface Table Mapping dialog box. It enters data into the Base Table name window of this dialog box. It derives this data from the table you located in Step 4.

In the Enter Column Name Prefix window, enter a prefix.

Siebel Tools does the following:

If a prefix does not already exist for the EIM table, then Siebel Tools adds the new prefix you enter to the EIM interface table columns that are related to the table.

If a prefix already exists for the EIM table, then Siebel Tools uses the existing prefix.

In the Select the Interface Table window, choose a value from the list, and then click Next.

Siebel Tools constrains the list you use to choose the EIM interface table to display only those interface tables to which your new custom table includes a foreign key relationship. Siebel Tools sorts this list by EIM table name. If the Exist field of the interface table is Y, then the EIM table is already mapped to the base table. If you extend a predefined Siebel table, then a table with a Y in the Exist field is an ideal candidate for EIM mapping.

Click Finish to accept the configuration and generate the EIM Interface Table object.

When you run the query, make sure the Changed property contains a check mark. Leave all other properties empty.

To verify the mapping, examine child objects.

Identify any new mappings that are not necessary.

If any new mappings are not necessary, then do the following:

Deactivate the unnecessary mappings.

Rename or delete the ORACLE_HOME\bin\diccache.dat file on the Siebel Server.

Run the following query to review any more columns that Siebel Tools generated:

T_*

Relations That the EIM Table Mapping Wizard Creates

Figure 86 illustrates relations between objects that the EIM Table Mapping Wizard creates. The wizard maps objects and adds child objects to the predefined EIM interface table object. For more information about EIM objects that the wizard creates, see Objects You Use with Enterprise Integration Manager.