Write a query to display Which deptno is containing highest
Sal > avg (sum (Sal)) of all deptno;
Avg (sum (Sal)) o f all deptno= 9675
Deptno, sum (Sal)
10 8750
20 10875
30 9400
- 7 Answers
- 11377 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / jz
select deptno,max(sal) from emp
group by deptno
having max(sal)>(select avg(sum(sal) )from emp
group by deptno)
:)
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
Explain scd type 3 through mapping.
Write the unconnected lookup syntax and how to return more than one column.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain in detail about scd type 1 through mapping.
draw informatica architecture 8.6 ?
Write the unconnected lookup syntax?
EXL informatica Questions
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How do you remove duplicate records in informatica? And how many ways are there to do it?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
