I am trying to implement SCD type 2 using tMysqlSCD.Below are the screenshots of my Job.
Below are primary Keys in Source table.
Below are primary Keys in Destination table.
Issue Description :
Scd_end,scd_version and scd_active do change when a there are changes for non-primary key field.(part of SCD type 2 field).
I am not sure if i am missing something.
Could you please help?
Thanks for your respone !
I tried your suggestion but unfortunately it is not working. I am using talend 6.1 Open studio.
Could you please advise?
tMySqlSCD works when data is loaded from Excel to Mysql table.
But fails when i load data from MySQL table to another MySQL table. Not sure if i am missing something.
Anyone please help?