How to validate schema in Talend using tSchemaCompileceCheck

Validates all input rows against a reference schema or check types, nullability, length of rows against reference values. The validation can be carried out in full or partly

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

The tFileInputDelimited component will detect only some of the anomalies within the data, whereas the tSchemaComplianceCheck component will perform a much more thorough validation of the data. If you look at the output, you will see the log entry, which shows that the name field has exceeded the maximum for the schema.

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

In the reject output, you can noticed that ErrorMessage “Exceed max legnth”.

Cheers! Uma