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.
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.
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema