Executing the Job to track data changes in a PostgreSQL table using tPostgreSQLSCDELT

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 26 is created for Teddy Brown's salary update from 13000.00 to 17000.00 because SCD Type 2 is performed on the salary column.