What is complex join? Difference with Foreign key Primary Key join?

-

 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

PK-FK is always 1-N and  complex joins can have (1-0,1) and (0,1-N).

PK-FK is always 1-N and  complex joins can have (1-0,1) and (0,1-N).

as per my knowledge i understand that 1-N is one -- many relation .

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

Foregin Key:- by using the forgin key we can define the joins between two tables. joins between is 1:M or M:M. if we want to define many:many relationship we have to use bridge tables.

how to configure the complex join? Ans:  complex join is that join within join where as two tables doesn't have any foreign key means at that time complex join is used

Comments

Post a Comment

Popular posts from this blog

Siebel REST API Interview Questions

-
Image
Question 1 : What are REST APIs?  Answer: REST stands for Representational state transfer. It is a protocol for data transfer using HTTP methods. Usually REST API uses JSON format to communicate as it is simpler and lightweight than XML uestion 2: Whats the architecture changes required in Siebel to implement REST API?  Answer:  Oracle has introduced java web containers and Proxy Object Manager to manage them at run time. Architecture looks like below: Question 3: What is the use of Siebel REST Proxy Object Manager? Answer: Siebel REST Proxy Object Manager is a new component which was introduced in Siebel IP17 to manage Java Web Containers on the Siebel Server. Requests from the web server is served by java web container by sending the request to EAI Object Manager. Siebel REST Proxy Object Manager is responsible for turning the Java Web Container On or Off. Question 4:  What are the URL Patterns for data and business services? Answer: Business services can be direct...
Read more

Siebel crm Best Bloggers/Blog sites

-
 Siebel Best Bloggers/Blog sites https://markenjam.blogspot.com/ https://medium.com/@markenjam https://siebelopenui.blogspot.com/ https://thesiebel.blogspot.com/ https://siebelenhance.blogspot.com/ https://crmcog.com/ https://geeksajan.blogspot.com/ https://thesiebelscholar.blogspot.com/ http://siebel.ittoolbox.com/blogs/ https://siebelhacker.blogspot.com/ https://siebelcrmmaterials.blogspot.com/ https://siebelexamples.wordpress.com/ https://siebelwizards.blogspot.com/ https://thealternatespace.blogspot.com/ https://siebelexpress.blogspot.com/ https://siebelexplored.blogspot.com/ https://siebel-ansari.blogspot.com/ http://www.error-codes.info/ https://crmknowledgebase.blogspot.com/ https://siebel360.blogspot.com/ https://siebel-learnings.blogspot.com/ https://www.impossiblesiebel.com/ https://weeklysiebel.blogspot.com/ https://exploringsiebel.blogspot.com/ https://siebelresources.blogspot.com/ https://siebelsupport.blogspot.com/ https://siebeltechhelp.blogspot.com/ https://yetanoth...
Read more

Siebel Web Service session management

-
  Siebel Web Service session management Using sessions can improve the performance of the web service calls as the session is kept open for subsequent requests.There is no need to login and logoff for each request. There are 4 different session types: None : A new session is opened for each request and then closed after a response is sent out. This is the default. Stateless : A new session is opened for an initial request and the session remains open for subsequent requests. Relogin occurs automatically (transparent to the user) if the session is closed. Stateful : A new, dedicated session is opened for an initial request and the session remains open for subsequent requests. Relogin does not occur automatically if the session is closed. To enable the session management you need to change the following: 1) Add "&WSSOAP=1" to the URL and remove the "UserName" and "Password" arguments from it as well as shown below: Original URL: http:/...
Read more