Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - How to list Top 10 salary, without using Rank Transmission?




1333
views
asked marvit September 20, 2014 08:05 AM  

How to list Top 10 salary, without using Rank Transmission?


           

1 Answers



 
answered By vishnoiprem   0  

METHOD 1:
Write sql override in the source qualifier t/r.
select columns from
( select columns,rank() over(order by sal desc ) as
rank from emp)
where rank <=10;

METHOD 2:

use sorter--> expression-->filter
1)sorter descend
2)use sequence generator connected expression to generator
sequence,
3)filter the value sequence number greater than 10
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert