Interested to Buy Any Domain ? << Click Here >> for more details...
you have two tables table 1 contains emp id,name and deptno
and tble 2 contains only depatment number some of the
depatment no of 1st table are not present in table 2 how
will you create a report only to get the departments of
which excess in table 1
- 4 Answers
- 7896 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / amutha
select empid,name,depno from table1,table2 where table1.deptno=table2.deptno(+)
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What is object stores?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Can you please send me the migration related issues .
What are the join problems comes appart from loop,chasm & fan Traps
What is a bo repository?
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?
What is package in BO
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?
is it possible to export the webi reports to crystal reports?with out using businessview?
Can more than 1 metric be applied on an analytic in business objects?
What is the difference between slice and dice and cross tab report?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
