Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajasekhar
hi,
The joins are two types... the first one is equi-join that
is using of = symbol.for example we have two tables called
wmp and dept. in emp we have deptno object. the same object
we have dept table also then we can create like this:
emp.deptno = dept.deptno.
The non-equijoin is with out same object from the both table
by using between keyword. we can take the bellow example
like emp(empno,sal) and salgrade(grade, lesssal,highsal) we
can create join from the aboue table like this: where sal
between lesssal and highsal.
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What are the steps to do to use alerts in bo?
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?
Explain how to execute the plsql procedure from the report by clicking with mouse?
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?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain about a time when you discovered a more efficient way to do a work task?
What would you consider as your biggest achievement and why?
Explain difference between zabo and webi?
Explain is there any default username & pwd for bo designer & supervisor?
What is Indexing? how did u implement indexing?
What three things do you consider to be the most important factors for a manager?
