chary

 Profile Answers by chary Questions by chary

• Feb 3rd, 2006

 

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.

raghavendra rajan

• Feb 3rd, 2006

 

Thanks aravind, but i am still not clear with 1:M extension tables. Can you explain again with some specific example. Thanks

Gaurav Rajpal

• Mar 4th, 2006

 

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. 

malli

• May 31st, 2006

 

 S_CONTACT_X is the extension table of S_CONTACT.if S_CONTACT Table don't have required columns to store the contact data then u used extension table columns(S_CONTACT_X).Here the relation is 1:1.

 if we want to store the contact related Educational data and restarunt data in a Single table , for this we are using   S_CONTACT_XM  table .Here the relation is 1: M.

raju

• Jun 5th, 2006

 

hi,

1:1 means one account is having one contact.

1:M means one account is having many contacts.

for suppose TCS is account it is having no of branches(contacts).

Nagendra Prasad M

• Aug 21st, 2007

 

There two types of extension table
1:1 Extension Table and 1:M Extension Table..
In case of 1:M extension table there three main columns presnt TYPE,PAR_ROW_ID,NAME.
For eg: Consider Contact and Hobbies.
One contact can have multiple hobbies,at this time only u can go for 1:M extension table,not in case of Account and Contacts.
Rgds,
Nagendra