I have a table(target) which has 5 rows , one of the column name:slno have values (12,13,14,34,56), I need to load data from my source table to target based on the max value of target. example
if in the source table for slno column values are (12,13,14,34,56,88,89,90,99) then only (88,89,90,99) values should go to target (along with all rows), basically I need to find max from target and based on that I need to load rows after that value.
Not able to figure out how to do, I heard of using tsetglobalvar, but no luck.
Have you tried tfilterrow? You can also do this with t(YourDB)Input and write your own select query. You can also set a filter in tMap.
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.