Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 siebel gateway?

1063


Is it possible to have multiple database servers for one gateway server?

1064


Explain while importing product or account data why we are populating bu_id?

922


i want interview question on siebel testing.very urgent

9648


How to configure a mvg?

1023


Explain how is siebel 7.x architecture different from siebel 6.x?

1074


Determine ootb functionality in siebel.

1095


Explain what is the difference between siebel 7.5 and 7.8? If we upgarde the application to 7.8 from 7.5 what are the areas we need to give importance fromqa(testing) point of view?

1128


How many type of siebel data model extensions are there?

970


How is load balancing maintained in the server?

1067


what is the difference between siebel 7.5 and 7.8? If we upgrade the application to 7.8 from 7.5 what are the areas we need to give importance from qa(testing) point of view?

1052


Why we using the user properties?

1101


How to improve your performance in views?

1004


What is Siebel file system?

1152


What exactly use of s_party concept in siebel?

1020