What is complex join?



What is complex join?..

Answer / edin

Complex joins are joins which have following diffrences
from a PK-FK joins???.
Complex joins can have conditional mappings like
>,<,>=,NOT,AND,etc apart from '=' whereas the PK-FK joins
are always '='

PK-FK joins are always (1-N), whereas complex joins can
have (1 - 0,1) and (0,1 - N) kind of relationships.

Complex join:- complex join are used in physical layer in
between two tables where ever that do not involved primary
key and foreign key relationship.

Is This Answer Correct ?    19 Yes 2 No

Post New Answer

More Siebel Interview Questions

By what way do you control Visibility in Siebel ?

2 Answers   Siebel Systems,


What are the different views available in Siebel?

0 Answers   Cap Gemini,


What is user properties?

0 Answers  


What is applet toggle how many types are there?

0 Answers  


Explain how does your b/c and view related?

0 Answers  






Explain how to run genbscript.exe?

0 Answers  


How to call external webpage from siebel application?

0 Answers  


Define position type field in position applet?

1 Answers   Siebel Systems,


What language you used to write bs?

0 Answers  


I want to see all the 6 static picklist values in one view and in another view i want to see 3 picklist values out of 6 values(I want to constrain 3 picklist values in another view out of 6 values) for the same field,same BC. how will u configure?

2 Answers   TCS,


i want to join in siebel testing so what was the prerequsites for that to learn? what is the siebel analytics

0 Answers   Oracle,


How do you disable a Siebel application user. how can we flag them, so that they are easily visible compared to active user in GUI.

0 Answers   HP,


Categories