Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10779 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / aashish
select department_ID, sum(salary) from emp group by department_ID having sum(salary) > (select avg(sum(salary)) from emp group by department_ID);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What are the tuning techniques you applied during your last project
Describe an informatica powercenter?
Mention few advantages of router transformation over filter transformation.
Define sessions in informatica etl?
Enlist some properties of sessions.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Where are the source flat files kept before running the session?
r u done any partitions in ur project?
explain about unit testing? in real time?
What is the difference between a connected look up and unconnected lookup?
Write the unconnected lookup syntax and how to return more than one column.
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Enlist few areas or real-time situations where informatica is required.
