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
- 5813 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 are the data types present in bo? What happens if we implement view in the designer and report?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
what is xcelsius architecture?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Is there any other repository domains rather than universe, security, document?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to open a universe with out using the Designer ??
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What is a fantrap in business objects?
Explain how we drill up week to month?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
How to generate the report from excel sheet?
When we use aggregate awareness function in designer?
Difference between zabo and webi?
