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
- 25871 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
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the guidelines to be followed while using union transformation?
If informatica has its scheduler why using third party scheduler?
wat are deployement groups in informatica, how it will be used for developers
How do you take back up of repository?
How to load a Dimension ? and how to load a fact table?
Explain the features of connected and unconnected lookup.
What is the difference between STOP and ABORT options in Workflow Monitor?
How can you validate all mappings in the repository simultaneously?
Why union transformation is an active transformation?
without table how to come first record only in oracle?
What are the advantages of informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
can anyone explain me about retail domain project in informatica?
What do you mean by blocking transformation?
