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

How to Get the MultiValueFields in Workflow

1858


Explain what is symbolic url in siebel?

581


How to create an extension table with an intersection table?

501


Explain what is the difference between "picklist generic" and "picklist hierarchical" business components?

525


What is the deployment options used for load balancing with netscaler?

539






How would you use or access more than one database at a single siebel application?

521


Explain the restrictions in siebel that comes while planning the networking topology.

518


How do you import list of values?

554


How would you import international phone numbers using eim in siebel realtime?

512


What is the process to create the dynamic drilldown?

584


i need to invoke an external web service from siebel CRM using as input to the web service a value in business component field, i need to display the results in another applet asociated with a virtual business component, does anyone know how to do this? thanks

2114


What are the 3 major steps in the event handler process?

557


When do we go for bc level user properties?

655


Explain the difference between join specification and join definition?

514


Suppose in an applet we have a button when we click on that button we need to get an business service. How we are going to do it?

520