1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

please anyone explain the equi join,outer joi(right outer
join and left outer join),theta join and self join with
database tables.

Question Posted / pradeep

Answers were Sorted based on User's Feedback



please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and..

Answer / punnaiahbabu

Equi join means equlity condition b/w tables
left outerjoin :matching and unmatching from left side onley
matched from right side.........
right outer join:matching and unmatching from right side
onley matched from left side.
outer join :matching and unmatching displed both of the tables
self join:we will right on sql query on the table.

Is This Answer Correct ?    7 Yes 0 No

please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and..

Answer / babu

Equai join: Matching records based on equality condition is
satisfied in the both the tables.
Left puter jion:All Records from left table only matcning
records form right table.
Right outer join:All records from right table and only
mating rows from left table.
theta join:Mating the records based on other than the
euality(ex:Age,Marks)
Self Join:It's a join with itself is called self join

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Business Objects Interview Questions

What is the difference between the prompt and cascading prompt

2 Answers  

how to solve the incompatible objects and how they are formed actually.

2 Answers   CTC,

draw the architecture of bo

0 Answers   IBM,

What is the pivot option ? what is the need of it?

1 Answers   Infotech,

WHAT IS CARDINALITY?

7 Answers  




Explain the difference between detect alias and detect context?

0 Answers  

what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash

2 Answers  

while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?

2 Answers   PWC,

How we can add a comment in universe...?

1 Answers  

How to get red line in the graph at some point (value)? Example : In graph at 200000 value

1 Answers   Rolta,

HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?

1 Answers  

In banking domain how many Fact tables,Dimension table are present?

0 Answers   TCS, UST,

For more Business Objects Interview Questions Click Here
Categories