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
- 26224 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 to update or delete the rows in a target, which do not have key fields?
How you prepared reports for OLAP?
Explain about Informatica server process that how it works relates to mapping variables?
What is meant by LDAP users?
Write the program through which the records can be updated?
If informatica has its scheduler why using third party scheduler?
what is INFORMATICA TESTING process
How to create Target definition for flat files?
Different circumstance which drives informatica server to expel records?
What is the difference between a connected look up and unconnected lookup?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain transaction control transformation in informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is the surrogate key?
What do you understand by term role-playing dimension?
