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

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.