topic Re: Inserts,updates,Deletes in single tMap in Talend Studio

Inserts,updates,Deletes in single tMap

ankushd — Wed, 17 Apr 2019 10:04:25 GMT

Hi All,

How we can find insert,update,delete records from single tMap for 2 inputs like old file& new file?

Anonymous — Wed, 17 Apr 2019 10:21:21 GMT

You will need to give more of an explanation of your problem I am afraid

ankushd — Wed, 17 Apr 2019 11:17:07 GMT

My basic requirement is to join 2 flat files to compare the records based on Key fields and find below output types.

Lets say i have file with name OLD & NEW

Insert - Records present in NEW File and not in OLD file

Update - Records present in both the inputs but changes in non key fields

Delete - Records present in OLD file but not in NEW file

manodwhb — Wed, 17 Apr 2019 11:24:49 GMT

@ankushd ,you can do with two tmaps,one to identify the new and updated and the other tmap to delete the records.