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?
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend