Interested to Buy Any Domain ? << Click Here >> for more details...
please anyone explain the equi join,outer joi(right outer
join and left outer join),theta join and self join with
database tables.
- 2 Answers
- 6328 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How to create Index to the table in the universe designer and how it improves the Query performence
What is object stores?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What is top business?
Differences between business objects and web intelligence reports?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain about a tricky situation for which you found a very simple solution?
Give some information on report bursting?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Can we create universe with no cache??
Can Bo generates the Report from the cubical data Explain?
Explain is data mart?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain what is the difference between business requirement document and use case document.
