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
- 8087 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vishal
select a.empid, a.name, a.deptno from table1 a, table2 b where a.deptno != b.deptno
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
Explain in detail about type 1?
How can you first report in Business Objects by using broadcast agent?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What sort of existing documents should business analysts refer to when starting on a new project?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Explain what task is 98% of the required work of a business analyst?
What is the difference between datawarehousing and businessintelligence?
what is document design in boxi,have u participate in that
Can we Save (save as) WEBI Doc as DESKI?
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 ?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
In banking domain how many Fact tables,Dimension table are present?
Explain which versions are used in the bo dashboard work?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
