Inserts,updates,Deletes in single tMap

[ankushd]

Hi All,

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

[Anonymous]

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

[ankushd]

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 · Accepted solution]

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