Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.