I have id and status column in my target table.
I will get id from source, if id is already exist and status, then i want to update the status='N' and insert a new records.
Please let me know, how do we check status in the target column and update the status='N'
Talend named a Leader.
Kickstart your first data integration and ETL projects.
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