August 15, 2023

Executing the Job to track data changes in a Snowflake table using tJDBCSCDELT – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Executing the Job to track data changes in a Snowflake table using tJDBCSCDELT – Docs for ESB 6.x

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

  1. Press Ctrl + S to save
    the Job.
  2. Press F6 to execute the
    Job.

    tjdbcscdelt_scenario_result.png

    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.

Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x