What is Join? Join Spec? Join Constraint?

Answers were Sorted based on User's Feedback



What is Join? Join Spec? Join Constraint?..

Answer / rama

Join spec means how u r going to pull the data

Join constraint means to restrict the join fields keep
search spec at column level

Is This Answer Correct ?    21 Yes 2 No

What is Join? Join Spec? Join Constraint?..

Answer / krish

Join is the relation between a BC to other than its base
table.

In Join ,it specifies from which table we get the data &
Join Spec specifies the mapping of Foriegn key column.

Join Constraint is to restrcit the data for join fields at
Search Spec level.........

Is This Answer Correct ?    13 Yes 3 No

What is Join? Join Spec? Join Constraint?..

Answer / shankar

Join is used to access data between two entities in same
applet. eg we can have contact and account fields in same
form or list applet

Join spec is used to relate the foreign key and primary key
relationship between the two entities (say in our case
between contact and account)

Is This Answer Correct ?    8 Yes 2 No

Post New Answer

More Siebel Interview Questions

Hi All, anyone can explain me about precision n scale properties. while extending one column in a table we will cum under these properties. Thanks n advance.

1 Answers   IBM,


Explain the netscalar one-arm mode deployment model.

0 Answers  


Explain what is an extension table and how is it related to base table?

0 Answers  


How is Siebel 7.x data model is different from Siebel 6.0 data model?

3 Answers   GE, Siebel Systems,


Is there any bounded and unbounded pick list in case of dynamic picklist

1 Answers   HP, Satyam,






Hirarchical pick is there in one applet, parent is "country" in this field "IND, USA" r there and child field "City" in this Hyd,Delhi, Bang for india and Newyork, washington for usa .Now if i select ind then Hyd... shown in child field then i select suppose hyd, now come parent field if i select usa & tabout the field still i see "Hyd" in child field unless i select the one of the city related to usa even though i check the immidiate postchange property in field level then how to i see it is Blank or related values

3 Answers  


What are "Renormalised columns"?

1 Answers  


Explain what is nameserver?

0 Answers  


How to give Access controls to the forms, EX: Manager should view all forms, but salesrep can view only "salesview" form in Siebel?

2 Answers   IBM,


Explain the difference between an organization and division in siebel?

0 Answers  


Explain dynamic picklist?

0 Answers  


What is purging in siebel?

0 Answers  


Categories