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
- 6395 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is difference between custom hierarchy and report based hierarchy?
what is document design in boxi,have u participate in that
Explain what is aggregate table and aggregate fact table ... Any examples of both?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
What are all difference between business objects 6.5 and xi r2?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
how many reports have u created ? explain a few.
what are the day to day activities of BO administrator ?
What is the difference between condition & filter?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
what is the difference b/w the refresh and buffered data?
What is aggregate table and aggregate fact table ... Any examples of both?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain what is the difference between business requirement document and use case document.
