Procedure
- Press Ctrl + S to save the Job.
-
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 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.