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
- 8079 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / taruna
The question is 'how to create a report' and not database query!!! We may apply MINUS operator between the two queries in query panel. This will give the difference.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to generate the report from excel sheet?
What is the functional & architectural differences between business objects and web intelligence reports?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
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)?
Explain the difference between detect alias and detect context?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
How would you format some text using css to be verdana and bold?
How we drill up week to month?
What is package in BO
What is the difference between business requirement document and use case document.
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
8. How much supervision have you typically received in your previous job?
