Link and Join

If you are facing siebel job interview, the probability of question " What is difference between Link

and Join? " is very high. Links and Joins have following differences in siebel world.





For experts : In a nut shell




Joins: Joins are configured between a Business Component and a table.

Links: Links are configured between 2 Business Components.

            They represent Parent Child relationship Cardinality:


Joins: Joins have 1:1 & M:1 cardinality.

Links: Links have 1:M & M:M cardinality.




Joins: Joins are configured as child properties of a BC.

Links: Links are created through Link Object in Siebel tools and they are referenced

           in Business Objects and Multivalue Links (MVL) to establish parent child relationship.




Joins: A Service Request can only have a single owner. So a Join is created in the

            Service Request BC to pull the owner information from the S_USER.

Links: An Account can have multiple Addresses. A link between BC: Account &

            BC: Business Address reflects this 1:M relationship.





For beginners : Below details will help freshers to understand clearly.



Link specifies the relationship between two business components. The relationship can be one-to-many (1:M), such as parent/child, or many-to-many (M:M).

A link implements a one-to-many (or master-detail) relationship between business components based on their base tables.

The Link object type makes master-detail views possible, in which one record of the master business component displays with many detail business component records that correspond to the master.


Join defines the logical join between a business component’s base table and another table.

A Join object definition creates a relationship between a business component and a table other than its base table.

The join allows the business component to use columns from that table.

The join uses a foreign key in the business component to obtain rows on a one-to-one basis from the joined table, even though the two do not necessarily have a one-to-one relationship.

3 comments on “Link and Join”

Leave A Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!