Setting up the Job

Procedure

In the Repository tree view, expand Metadata - DB Connections where you have stored the main input schema and drop the relevant file onto the design workspace.
The Components dialog box displays with the corresponding component selected by default.
Click OK to drop the tMysqlInput component onto the workspace.
The input table used in this scenario is called translation. It holds several columns including the translation column that holds the English words we want to stem.
Drop the following components from the Palette onto the design workspace: tNormalize, tFilterRow, tStem, tAggregateRow and tFileOutputExcel.
Connect the component together using the Main links with the exception of the tFilterRow - tStem connection that should use a Filter link.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!