1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

how to find the 5th highest salary form each department
using 1.SQL Query
2. Informatica power center designer?

Question Posted / kondeti srinivas

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


Please Help Members By Posting Answers For Below Questions

how we can load rejected record's at run time?(not through bad files)

1906

Explain how many types of dimensions are available in informatica?

590

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1548

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5770

Please let me know how to make Data masking in informatica..

1263




I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1627

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

630

Explain informatica architecture - version 8 / 9

663

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1527

where to store informatica rejected data?

672

What is joiner transformation in informatica?

623

What is a sorter transformation?

657

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.

767

Please let me know how to make encryption and decryption with example?

1460

What do you understand by SOA of Informatica?

583