Updating the employee data in MySQL using SCD

SCDELT

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Open Studio for MDM
Talend Open Studio for ESB
Talend Big Data
Talend Real-Time Big Data Platform
Talend Data Integration
Talend MDM Platform
Talend Open Studio for Big Data
Talend Big Data Platform
Talend Open Studio for Data Integration
Talend Data Services Platform
Talend Data Management Platform
Talend Data Fabric
Talend ESB
task
Design and Development > Third-party systems > Business Intelligence components > SCDELT components
Data Governance > Third-party systems > Business Intelligence components > SCDELT components
Data Quality and Preparation > Third-party systems > Business Intelligence components > SCDELT components
EnrichPlatform
Talend Studio
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.