Skip to main content Skip to complementary content

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 – please let us know!

Leave your feedback here