Interested to Buy Any Domain ? << Click Here >> for more details...
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department.
Write a query
- 7 Answers
- 12434 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / murali krishna udayagiri
SELECT E.* FROM EMP E ,(SELECT DEPTNO,AVG(SAL) AVGSAL FROM
EMP GROUP BY DEPTNO) E1
WHERE E.SAL>E1.AVGSAL
AND E.DENPTNO=E1.DEPTNO;
Thanks,
Murali Udayagiri
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Is it possible to define a single node as a Gateway node as well as worker node?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is a filter transformation and why it is an active one?
How to load a Dimension ? and how to load a fact table?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How to improve the performance of a session using sorter transformation?
Explain sessions and how many types of sessions are there?
Mention few advantages of router transformation over filter transformation.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the types of presistent cache in look up tr.
Explain the informatica workflow?
Define enterprise data warehousing?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
