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.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.