I'm inserting data from one table to another table and i need to capture only change data on the next run.And the talend job should check all the columns , compare current table column data with the previous column data available in previous table column to column comparison should happen and all columns should be checked , even if there is insert/change in single column out of 20 columns, we should consider that as changed data and get the whole record into a new table.Please help me how to get only the modified data.
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
In that case I would recommend you to load the data to a stage table using Talend and then do the data comparison either with a tMap or using a tMSSQLServerRow component. If you are using Row component, then you will have to write SQL commands or stored procedure to do the data difference check.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
