please anyone explain the equi join,outer joi(right outer
join and left outer join),theta join and self join with
database tables.
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
How to create Index to the table in the universe designer and how it improves the Query performence
Explain how many universes can be created in a project?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Did you face any problems while creating reports? Name? Solutions?
how get the grand total in master-detail report?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What is package in BO
what is universe null
8. How much supervision have you typically received in your previous job?
Can more than 1 metric be applied on an analytic in business objects?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
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.
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.