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 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

Siebel CRM Overview

-
Image
  What Is CRM? Customer : A Customer is someone who makes use of or receives the products or services of an       individual or organization R elationship : A  Relationship  is a way in which customers and organizations are connected to each other. M anagement :  Management  is a process by which the relationship between customers and organizations is handled efficiently and effectively. Company Structure - Siebel Company Structure   Company deploying the siebel applications use the following entities to structure the data access.   ·                   Divisions :  Are used for purpose of mapping a company's physical structure. It represents the part of the company such as a line of business, a geographical location, business unit or department. ·                   Positions :  Represents the job title with in the company or the partner company. It is more stable structure than representing the individual person. ·                   Employees :  Represents
Read more

Siebel all user properties /different object types/ Field User Property

-
 Following user properties examples with different object types: Application User Properties ClientBusinessServicen: Allows you to call business services from a browser script BC Level User Properties Read Only Field: When the value of the field specified in this user property is TRUE, the current record is read-only. Parent Read Only Field: When the value of the specified field evaluates to TRUE or Y, the current business component becomes read-only. Deep Copy n: Allows child business components and their respective child business components to be copied automatically when selecting the Copy option. Deep Delete n: Allows child business components and their respective child business components to be deleted automatically when selecting the Delete option. Applet User Properties CanInvokeMethod: MethodName :Is used to enable and disable methods declaratively. When the value is TRUE or the expression returns TRUE, then the method is enabled, otherwise it is disabled. Show Required n: Allo
Read more