Skip to main content Skip to complementary content
Announcements

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

Procedure

  1. Double-click the second tFixedFlowInput component to open its Basic settings view.
  2. Click the 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. 
    1;Mark Smith;31;tester;11000.00
2;Thomas Johnson;32;developer;12000.00
3;Teddy Brown;33;writer;13500.00
  4. Repeat 4 through 10 in the procedure Inserting the employee data into a MySQL table using SCD to configure the second tMysqlSCD 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 – let us know how we can improve!

Leave your feedback here