Configuring Siebel Business Applications > Transferring Data Between Databases > Mapping a Custom Table to an Interface Table >

Guidelines for Using the EIM Table Mapping Wizard


If you use the EIM Table Mapping Wizard, then use the following guidelines:

  • You must set the Type property for any table you use with the EIM Table Mapping Wizard to one of the following values:
    • Data (Public)
    • Data (Intersection)
    • Extension
    • Extension (Siebel)
  • You cannot use the EIM Table Mapping Wizard with a custom table because there is no EIM table to choose in the EIM Table Mapping Wizard.
  • You can map a single column in an interface table to multiple base tables or extension tables. However, do not map multiple interface table columns to a single column in a target table because it can create ambiguity for EIM.
  • EIM does not validate an interface table or a column definition. EIM validates a list of values against the lists of values that are defined for the base columns to which the values are mapped.

Restrictions on Adding or Modifying EIM Mappings

Table 67 describes restrictions on adding or modifying EIM mappings.

Table 67. Restrictions on Adding and Modifying EIM Mappings
From
To
Restriction

Interface table column

Base column

Supported if there are predefined mappings from the interface table to the data table.

Interface table extension column

Base column

Supported if there are no other mappings to the base column. Use with caution.

Interface table column

Extension table column

Supported if there are predefined mappings from the interface table to the base table of the extension table.

Interface table extension column

Extension table column

Configuring Siebel Business Applications Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.