how to find the 5th highest salary form each department
using 1.SQL Query
2. Informatica power center designer?
- 4 Answers
- 25140 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
Briefly describe lookup transformation?
How do you load only null records into target?
Difference between Target-based loading and constraint-based loading?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
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.
Scheduling properties,whats the default (sequential)
What are the different types of olap? Give an example?
Write the different tools in the workflow manager?
Reusable transformation and shortcut differences
What is an expression transformation in informatica?
How to start a workflow using pmcmd command?
Explain the different kinds of facts.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are data-driven sessions?
What are the mapping parameters and mapping variables?
