How to find Employee with max(salary) in each department via Informatica PowerCenter

[@Vabcdefgh]

I have a scenario
I want to load top 3rd salary record using informatica

[@nidhisharma3102]

Very Nice Video. Keep it up. Your 1st subscriber 😍

[@sudheerdevisetti]

if, I need the 2nd highest salary by department wise mean..how to achieve that.

[@jagadeeshm3119]

Sir We can write the above query in source qualifier query option

[@utsav7027]

Of course you can. The point of the video is to achieve this via Informatica. Imagine if the source is a flat file, then you have to use Informatica transformations to achieve it.

[@venkateswarlupamula4207]

Super sir