A source table contains emp_name and salary columns.
I want to have a mapping to load all records with 5th highest salary into the target table.
Solved! Go to Solution.
The best option is making from the source, if your source is oracle you could make a query that returns you the 5 rows you need.
Also you could use a tSortRow component sorting column salary in desc order, then a tmap component where you declare a var with numeric sequence (using the internal talend function) from value1 and increment by 1, and an output with a condition where you evaluates this variable and if its value is between 1 and 5 then the output is valid.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables