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
- 26089 Views
- CTC, I also Faced
- E-Mail Answers
Answer Posted / yaseen
Select deptno,distinctsal from emp A where 5= (select count(distinctsal) from emp B where A.sal <= B.sal) groupby deptno
SQ----Rank TR-----Target
Rank t/R ---Group by on Deptno, Top --5
Plz correct if I am wrong
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How to load the data from people soft hrm to people soft erm using informatica?
During the running session, output files are created by informatica server. Enlist few of them.
what is diff b/t sorter t/r and agg have the option sorter property...
What are the performance considerations when working with aggregator transformation?
Design a mapping to load a target table with the following values from the above source?
What is dimensional table? Explain the different dimensions.
What is a passive transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
what is the difference between informatica6.1 and infomatica7.1
How does a sorter cache works?
What is mapplet in informatica?
What is a repository manager?
