please anyone explain the equi join,outer joi(right outer
join and left outer join),theta join and self join with
Answers were Sorted based on User's Feedback
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|
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
Self Join:It's a join with itself is called self join
|Is This Answer Correct ?||2 Yes||0 No|
What is shortcut join?could give any one example?
define universe parameters?
HOW DO YOU SCHEDULE THE REPORTS?
i want to hide a chart in reporting level? i want to hide a prompt in designer level?
I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?
1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?
how we transport universes from business objects 6.5 to BOXI R2?
what is main functional differences between BO and COGNOs?
What is the difference between Thin client & thick client?
is it possible to export the webi reports to crystal reports?with out using businessview?
CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?
Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?