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
What we need to discuss with designer before starting the universe designing.
Explain when we use aggregate awareness function in designer?
Can more than 1 metric be applied on an analytic in business objects?
Can Bo generates the Report from the cubical data Explain?
Explain when to use local filter and when to use global filter?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
what is xcelsius architecture?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
What would you consider as your biggest achievement and why?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?