Skip to main content Skip to complementary content

Linking the components

Procedure

  1. Drop the DB Connection under the Metadata node of the Repository to the design workspace. In this example, the source table is called people_age.
  2. Select tMysqlInput from the list that pops up when dropping the component.
  3. Drop the lookup DB connection table from the Metadata node to the design workspace selecting tMysqlInput from the list that pops up. In this Job, the lookup is called large_data_volume.
  4. The same way, drop the DB connection from the Metadata node to the design workspace selecting tMysqlConnection from the list that pops up. This component creates a permanent connection to the lookup database table in order not to do that every time we want to load a row from the lookup table.
  5. Then pick the tMap component from the Processing family, and the tMysqlOutput and tMysqlCommit components from the Database family in the Palette to the right hand side of the editor.
  6. Now connect all the components together. To do so, right-click the tMysqlInput component corresponding to the people table and drag the link towards tMap.
  7. Release the link over the tMap component, the main row flow is automatically set up.
  8. Rename the Main row link to people, to identify more easily the main flow data.
  9. Perform the same operation to connect the lookup table (large_data_volume) to the tMap component and the tMap to the tMysqlOutput component.
  10. A dialog box prompts for a name to the output link. In this example, the output flow is named: people_mixandmatch.
  11. Rename also the lookup row connection link to large_volume, to help identify the reference data flow.
  12. Connect tMysqlConnection to tMysqlInput using the trigger link OnSubjobOk.
  13. Connect the tMysqlInput component to the tMysqlCommit component using the trigger link OnSubjobOk.

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!