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
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Give some information on report bursting?
any difficulitis have you phase while creating bo reports and how did u solve it
What is a bo repository?
in sap bi we have wad, then why we go for sap bo
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Can anybody tell me what are the tuning problems?
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 in detail about type 2(scd),
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How can you first report in Business Objects by using broadcast agent?
What is difference between webi and infoview?
Which versions are used in the bo dashboard work?
What is a fantrap in business objects?
Explain what are the steps to do to use alerts in bo?