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.
HAI IAM VISNU. IAM VERY MUCH INTERESTED IN BLOGS AND POSTING QUICK REPLIES TO YOUR BLOGS.
ReplyDeleteCAN 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
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.
ReplyDeleteWe 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
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
ReplyDeleteplease reply me sooon
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
ReplyDeleteplease reply me sooon
Hi,
ReplyDeleteThese topics and real time interview questions are really useful and intresting.
Many thanks to you.
Thanqqq very much,ypur blog is really very usefull
ReplyDeleteExcellent Post !!
ReplyDelete