Siebel General - What is the difference between Join and Link?

GeekInterview.com > Interview Questions > Siebel > Siebel General

Go To First | Previous Question | Next Question

Siebel General | Question 49 of 170

What is the difference between Join and Link?

Total Answers and Comments: 5

Last Update: December 26, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: Vinayan

Join is used for showing fields from multiple tables in a BC. It draws one to one and many to one relationship between the base table and the join table.

Link defines the Master - Detail relationship between Parent and child BC's. It architects one to many and many to many relationship between BC's.

Above answer was rated as good by the following members:
ffpradella

September 16, 2005 18:52:36

suvasa

RE:

Join:

(i)It defines M:1 relation between a field in BC to the Column in table.

(ii)Source Field is the Foreign key field in BC while Destination column is the Primary Key column in Table.

Link:

(i)It defines 1:M relation between a field in parent BC to the field in the child BC.

(ii)Source Field is the Primary Key field in Parent BC while Destination Field is the Foreign Key field in child BC.

Is this answer useful? Yes | No

November 14, 2005 12:09:03

Mano

RE: what is the difference between Join and Link?

JOIN: gives relationship between two tables.LINK: Gives relationship between two BCs.in link child Bc is included under parent Business Object.

Is this answer useful? Yes | No

March 16, 2006 04:50:08

pavansingadi

Member Since: March 2006 Contribution: 15

RE: what is the difference between Join and Link?

Join is between BC and table and is used to retrieve no or atmost one record.where Link is between two BC's which will retrieve more than one record for a parent record.

Is this answer useful? Yes | No

May 24, 2008 01:21:52

Vinayan

Member Since: May 2008 Contribution: 6

RE: What is the difference between Join and Link?

Join is used for showing fields from multiple tables in a BC. It draws one to one and many to one relationship between the base table and the join table.

Link defines the Master - Detail relationship between Parent and child BC's. It architects one to many and many to many relationship between BC's.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

December 26, 2008 01:17:37

sreevallicr

Member Since: December 2008 Contribution: 1

RE: What is the difference between Join and Link?

link object type makes master detail view possible in which one record of master bc displays with many detail bc records associated with that master bc.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank