Siebel CRM Question:
Download Questions PDF

What is the difference between 1:1 and 1:M extension tables?


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.

Download Siebel Interview Questions And Answers PDF

Previous QuestionNext Question
What difference between Fields and single value fields?What is complex join? Difference with Foreign key Primary Key join?