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

80 views Asked by At

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
1

There are 1 answers

0
Maciejg On

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

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