Skip to main content Skip to complementary content

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


  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 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.

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 – let us know how we can improve!