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
- 25952 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
how to load rows into fact table in data warehouse
What is native users?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is mapping debugger?
What are the popular informatica products?
What is informatica? Why do we need it?
can you please explain me pre session and post session options?
What are the components of Informatica? And what is the purpose of each?
what is the complex transformation you used in informatica
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
permutations of mapplet
What are data-driven sessions?
What is a snowflake schema?
What is rank transform?
How to delete duplicate row using informatica?
