Configure the second tFixedFlowInput component and the second tMysqlSCD component to update the employee data in MySQL using SCD (Slowly Changing Dimensions).
- Double-click the second tFixedFlowInput component to open its Basic settings view.
- 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.
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
- Repeat 4 through 10 in the procedure Inserting the employee data into a MySQL table using SCD to configure the second tMysqlSCD component.