Adding and linking the components
-
Drop the following components from the Palette onto the design workspace: tMysqlConnection, tFixedFlowInput, tMysqlOutput,
tCreateTable, tCombinedSQLInput, tCombinedSQLFilter, tCombinedSQLAggregate, tCombinedSQLOutput, tMysqlCommit, tMysqlInput and
tLogRow. -
Connect tMysqlConnection to tFixedFlowInput using a Trigger > On Subjob Ok link
-
Do the same to connect tFixedFlowInput to
tCreateTable, tCreateTable to tCombinedSQLInput, tCombinedSQLInput to tMysqlCommit, and tMysqlCommit
to tMysqlInput. - Connect tFixedFlowInput and tMysqlOutput using a Row > Main link.
- Connect tCombinedSQLInput to tCombinedSQLFilter using a Row > Combine link.
-
Do the same to connect tCombinedSQLFilter to
tCombinedSQLAggregate, and tCombinedSQLAggregate to tCombinedSQLOutput
-
Connect tMysqlInput and tLogRow using a Row >
Main link.
Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Login
0 Comments