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
- 25886 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
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain about cumulative Sum or moving sum?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the features of complex mapping?
What is informatica etl tool?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How can we handle two sessions in informatica?
What is domain in terms of informatica?
Different circumstance which drives informatica server to expel records?
Describe an informatica powercenter?
Briefly define a session task?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the issues you have faced in your project? How did you overcome those issues?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Do you find any difficulty while working with flat files as source and target?
