Procedure
- From the Palette, drop these components onto the design workspace: a database input component and a database output component, here tMysqlInput and tMysqlOutput, to upload the data, a tLogRow component to display the rejected data in the console and a tJava component to display the number of lines processed in the console.
-
Connect the input and output database components using a Row > Main connection, and connect the tMysqlInput to the tJava
components using a Trigger > OnSubjobOk connection.
Note:
You will be able to create the reject link between the tMysqlOutput and tLogRow components only when you will have applied the validation rule to the tMysqlOutput component.