Bookshelf Home | Contents | Index | PDF |
Siebel Enterprise Integration Manager Administration Guide > EIM: Examples of Common Usage > Examples of Resolving Foreign Keys > Example 3: Resolving the Foreign Key Using a Special User KeyThis example is specific to Siebel Industry Applications (SIA). A typical example of using a special user key (rather than the normal U1 user key) to resolve foreign keys is the use of the special user key "S_ADDR_PER:Communications" in the resolution of foreign keys to S_ADDR_PER in SIA. This special user key contains only the column ADDR_NAME, in contrast to (ADDR_NAME, PER_ID) in the U1 user key. The mapping of S_ORDER.BL_ADDR_ID in EIM_ORDER, for example, uses the special user key "S_ADDR_PER:Communications" instead of the U1 user key. In fact, mappings of all foreign keys to S_ADDR_PER in SIA use this special user key instead of the U1 user key. |
Siebel Enterprise Integration Manager Administration Guide | Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |