to find the highest sal employees and add only those employess in target by using IICS or informatica

Question

My source is like

enter image description here

emp_id name  sal
101    tina  10000
102    mega  10000
103    meena 5000

I need the details of the employees 101 and 102 details:---like this

emp_id name  sal
101    tina  10000
102    mega  10000

Answer 1

Read the data, use Aggregator to find max value, and join the max with the original data set.

Src-SQ----Agg--\
      \---------Jnr---Tgt