Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the 5th highest salary form each department
using 1.SQL Query
2. Informatica power center designer?
- 4 Answers
- 26088 Views
- CTC, I also Faced
- E-Mail Answers
Answer Posted / kondeti srinivas
sql query:
SELECT * FROM (SELECT DEPTNO,SAL,RANK()OVER (PARTITION BY DEPTNO ORDER BY SAL DESC) AS RNK) WHERE RNK=5
IN INFORMATICA
SOURCE ---SQ--RANK TANSFORMATION IN THAT SELECT DEPTNO AS GROUP BY PORT AND SAL AS RANK PORT AND SELECT TOP AND RANK =5
OUT PUT FROM RANK WILL BE DEPARTMENT WISE TOP 5 SALARIES ARE DISPLOYED AND FROM RANK TRANFORMATION CONNECT ALL PORTS INCLUDE RANKINDEX TO FILTER GIVE A CONDITION LIKE RANKINDEX=6
AND CONNECT ALL PORTS TO TARGET
| Is This Answer Correct ? | 14 Yes | 6 No |
Post New Answer View All Answers
What is meant by lookup transformation? Explain the types of lookup transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the tasks that can be performed using sq?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is aggregate cache in aggregator transformation?
What is expression transformation?
What is union transformation in informatica?
How to differentiate between the active and passive transformations?
Can anyone tell me the new features in Informatica 9 Version?
Reusable transformation and shortcut differences
How many number of sessions can one group in batches?
How can a transformation be made reusable?
What are session parameters ? How do you set them?
What is pmcmd command?
