Monday, December 29, 2008

Join v/s Link : Interview Question

I was just sitting with my colleagues and suddenly one of junior member of our team asked what is the difference between a Join and Link? He was new to Siebel and started learning it, so I thought to make him understand my way. Here is what my view point says :

Anybody came from database background knows, "Cardinality" between two tables can be of four types :
a) One to One
b) One to Many

c) Many to One
d) Many to Many

So, a very simple way to define a Join in Siebel is, "When you have "One" on the right side of the cardinality, there you need to implement Join". Similarly, "When you have "Many" on the right side of the cardinality, there you need to implement Link". That means, "One to One" and "Many to One" corresponds to the Join, while "One to Many" and "Many to Many" corresponds to the Link.

Secondly, a Join exist between a Business Component & a table while Link always exists between two different business Components.

Thirdly, via Join system fetches a single record while Link fetches multiple records.

Fourthly, while implementing Join, we can use the "Join Constraint" to specify the condition on the child entity. In link, we can specify the condition on child entity by putting "Search Specifications".

Note : For "Many to Many" link, we need to make use of Inter table which stores the unique Id of Parent and Child Business Component.

7 comments:

  1. HAI IAM VISNU. IAM VERY MUCH INTERESTED IN BLOGS AND POSTING QUICK REPLIES TO YOUR BLOGS.
    CAN YOU TELL ME HOW CAN WE USE BUSCOMP USER PROP AND APPLET USER PROP
    I HAVE AONE REQUIREMENT IF USER SELECTS MARRIED FLAG FIELD THEN HE NEED TO ENTER SPOUSE NAME. SO MAKING AS REQUIRED FILED DEPENDING ON OTHER FIELD
    IT CAN BE DONE THROUGH THE FIELD USERPROP BUT HOW CAN I APPROACH CAN YOU GIVE ME MANUAL STEPS

    ReplyDelete
  2. Many many thanks to you. There are many ways to serve the nations, but you have choosen a unique way to serve the World. No body can imagine what amount of money and time you are saving by contributing your experience, learnings and effort to come with new concept of Siebel. I salute you for your initiative.
    We all must support, contribute and use the information on this blog. You are a true mentor and people will be benefitted by this blog.
    Thanks Again
    Amit Kumar Srivastava

    ReplyDelete
  3. Hai I know about constraining picklist but here the situation different Gaurav when we checkbox true then constraining happens to the between two picklist(static) other wise both are independent i think you got my point thank you
    please reply me sooon

    ReplyDelete
  4. Hai I know about constraining picklist but here the situation different Gaurav when we checkbox true then constraining happens to the between two picklist(static) other wise both are independent i think you got my point thank you
    please reply me sooon

    ReplyDelete
  5. Hi,

    These topics and real time interview questions are really useful and intresting.
    Many thanks to you.

    ReplyDelete
  6. Thanqqq very much,ypur blog is really very usefull

    ReplyDelete
  7. Excellent Post !!

    ReplyDelete