Siebel CRM Question:
Download Job Interview Questions and Answers PDF
What is complex join? Difference with Foreign key Primary Key join?
Answer:
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 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
Download Siebel Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is the difference between 1:1 and 1:M extension tables? | What is Localisation? |