|
what is the difference between 1:1 and 1:M extension tables
SIEBEL Interview Questions
(Continued from previous question...)
what is the difference between 1:1 and 1:M extension tables
A1: 1:1 extension table is like an extension to the base table. if we do not have the required table space in the base table for craeting new extension columns, we will use the 1:1 extension table's columns using an implicit join.
in contrast, 1:M extension tables are used for parent child relationship with the base table. where the 1:M extension has only related to the base table. for example, for a contact (S_CONTACT) there will be a number of specialities in the extension table(S_CONTACT_XM) with the parent child relationship.
A2: In Siebel for the base tables like S_CONTACT suppose you have 3 address for a perticular contact. A person is working at 2 places plus his home address. Now you can not store this is in S_Contact as every contact has a unique row id and that can not be repeated. So you have S_CONTACT_XM. i.e an extension table to S_CONTACT but with 1:M relation.
(Continued on next question...)
Other Interview Questions
| 