Skip to main content Skip to complementary content
  • New archived content: Talend MDM, Talend Data Catalog 8.0, and Talend 7.3 products reached their end of life in 2024. Their documentation was moved to the Talend Archive page and will no longer receive content updates.

Executing the Job to track data changes in a Snowflake table using tJDBCSCDELT

Procedure

  1. Press Ctrl + S to save the Job.
  2. Press F6 to execute the Job.

    As shown above, the old role developer for Thomas Johnson is overwritten directly by the new role tester because SCD Type 1 is performed on the role column, and a new record with the surrogate key value set to 4 is created for Teddy Brown's salary update from 16000.00 to 17000.00 because SCD Type 2 is performed on the salary column.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here