Amit

• Dec 12th, 2006

 

Join : It is based on table. Using join you can access the data from different table.

Two types of Join
1) Implicit Join : it is 1:1 join based on extension table(Name_X tables). Siebel created joins.
2) Explicit Join : it is 1:M join based on extension table(Name_XM). In this you map the primary & foreign key.

Link : It is based on Business Component. Basically use to establish a relationship between two BC's.

Two types of Link
1) 1:M Link : in this we map the primary & foreign key. Foreign key is on the many side. In this we specify Source & Destination field.
2) M:M Link : in this we have to specify the intersection table with intersection parent column & child column.

anurag2284

 Profile Answers by anurag2284 

• Mar 22nd, 2009

 

Small correction in Amit's answer that explicit joins are based upon M:1 relation.