August 15, 2023

Updating the employee data in MySQL using SCD – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Updating the employee data in MySQL using SCD – Docs for ESB 6.x

Updating the employee data in MySQL using SCD

Configure the second tFixedFlowInput component and the second tMysqlSCD component to update the employee data in MySQL using SCD (Slowly
Changing Dimensions).

  1. Double-click the second tFixedFlowInput component to open its Basic
    settings     view.
  2. Click the

    components-button_three_dot.png

    button next to Edit schema and
    in the pop-up window define the schema by copying and pasting the schema of the
    first tFixedFlowInput component.

  3. In the Mode area, select Use Inline Content (delimited file). Then in the
    Content field displayed, enter the following
    updated employee data.

  4. Repeat 4 through
    10 in the procedure Inserting the employee data into a MySQL table using SCD to configure the second tMysqlSCD component.
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