Setting up the Job environment for a reference validation rule

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.

Information noteNote:
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.

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!