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
- 26031 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
Whats there in global repository
Which development components of informatica have the highest usage?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is a sequence generator transformation?
What is rank transform?
What is target designer and target load order?
What is dynamic cache?
Differentiate between reusable transformation and mapplet.
Please let me know how to make encryption and decryption with example?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Why sorter is an active transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Explain incremental aggregation in informatica
How to create the source and target database connections in server manager?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
