Configure the second tFixedFlowInput component and the second tMysqlSCD component to update the employee data in MySQL using SCD (Slowly
Changing Dimensions).
Procedure
-
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.