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
- 6356 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
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
(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.
How many universes can be created in a project?
Explain about a time when you discovered a more efficient way to do a work task?
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?
how get the grand total in master-detail report?
Can anybody tell me what are the tuning problems?
What is the difference between the public object&schema object?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain the difference between detect alias and detect context?
What is report template in b.o?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Explain which versions are used in the bo dashboard work?
