Written on January 29, 2009 at 6:07 am by neel

What is difference between Link and Join?

Filed under Configuration View Comments

Links and Joins have following  differences

Relationship:
 
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.
 
Configuration:
 
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.
 
Examples:
 
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.

Related Questions

Subscribe / Share

Article by neel

Authors bio is coming up shortly. neel tagged this post with: , , , Read 39 articles by neel
  • Dennis Anthony
    Guys,

    This is one portal which has helped me gain a lot of confidence in what I work in Siebel. I have always had confusion in understand some of the basic concepts which I got clarified in very simple and understandable language.

    Thanks
  • Amu
    Just to add to Vishnu`s comment:

    In a join, the Destination Column : Primary key (ROW_ID) is of the joined table and the Source Field : Foreign key on base BC

    In a Link, The Source Field is the id of the Parent BC, and the Destination Field is the FK in the child BC

    Hope I got it right :P
  • vishnu
    hai in addition to this we can have
    Joins: The source and destination fields for the join foreign key and primary key.
    Link: The source and destination fields for the Link is primary key and foreign key.
blog comments powered by Disqus
analytics base tables Black Box Testing business component business components business service business services Configuration EIM eScript exception handling exceptions fact tables Functional Testing Informatica Interview Link Specification Local Client memory management mvl parent child relationship Position QTP repository Responsiblity Scripting Search Spec sequence generator server administration server requests siebel Siebel EAI Siebel Testing Siebel Tools Software testing Software Validation surrogate key synchronous execution synchronous mode table tables testing User Properties User property workflow Workflows