Skip to main content Skip to complementary content

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!