Skip to main content Skip to complementary content

Creating a Job for tracking data changes in a PostgreSQL table using tPostgresqlSCDELT

Procedure

  1. Create a new Job and add a tPostgreSQLConnection component, a tCreateTable component, two tFixedFlowInput components, two tPostgreSQL Input components, two tPostgreSQLOutput components, two tPostgreSQLSCDELT components, and two tLogRow components to the Job.
  2. Link the first tFixedFlowInput component to the first tPostgreSQLOutput component using a Row > Main connection.
  3. Do the same to link the first tPostgreSQLInput component to the first tLogRow component, the second tFixedFlowInput component to the second tPostgreSQLOutput component, and the second tPostgreSQLInput component to the second tLogRow component.
  4. Link the tPostgreSQLConnection component to the tCreateTable component using a Trigger > On Subjob Ok connection.
  5. Do the same to link the first tFixedFlowInput component to the first tPostgreSQLSCDELT component, the first tPostgreSQLSCDELT component to the first tPostgreSQLInput component, the first tPostgreSQLInput component to the second tFixedFlowInput component, the second tFixedFlowInput component to the second tPostgreSQLSCDELT component, the second tPostgreSQLSCDELT component to the second tPostgreSQLInput component.

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!