When row is deleted, the end date in scd type 2 should get updated with that datetime details

[Anonymous]

Hi team,

I'm newbie to talend. I'm currently working on creating a flow to load data daily from data source to my scd type2 table. 

1. If a new row based on primary key is loaded, it should insert new row.
2. If there is change on existing row, the old row should be closed (start date, end date) and new row with end date as null should be created.
3. If a row is deleted on primary key, then the end date for that row should be given.

Using tDBSCD, I'm able to solve cases 1,2. I need suggestions for case 3, where when a row is deleted, the end date is not getting updated with the time stamp.

[Raghuram_Puram]

Since you are using SCD components, you might additionally need to perform a lookup of incoming data with existing records and can catch the deleted records in tMap using "Catch Inner Join Reject" option on tMap output side.

Note: Lookup join should be Inner Join for this case.