What is complex join?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is the significance of eapps.cfg file?

483


How to create extension table to an interface table in siebel?

523


What is the difference between eim and eai?

660


How would you import url links into the s_lit base table?

477


Explain the function of nameserver?

531






What is the difference between mvg applet and a pick applet?

576


Describe the 3 object explorer (oe) tabs?

647


what is the difference between join and link?

589


What is the use of detailed category in configuration?

485


What is inbound in picklist?

511


What are the steps required to set the policy expression?

465


What is purging in siebel?

601


Suppose if we have dynamic picklist as bounded can we add field?

503


What is the difference between an organization and division in Siebel?

549


What is the process of configuring siebel 8 web virtual server?

522