Talend Open Studio Cookbook

Validating against the schema

The tSchemaComplianceCheck is a very useful component for ensuring that the data passing downstream is correct with respect to the defined schema.

This simple exercise demonstrates how rows can be rejected using this component.

Getting ready

Open the job jo_cook_ch03_0020_schemaCompliance.

How to do it…

1. Run the job. You should see two rows being rejected.
2. Add a tSchemaComplianceCheck and two tLogRow, right click on tSchemaComplianceCheck_1 and select Row then Rejects. Join the flow one of the new tLogRow. Connect the main to the other as shown:
   
3. Now, when you run the job, you will see an additional reject row being output from ...