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.
Add a
tSchemaComplianceCheck
and twotLogRow
, right click ontSchemaComplianceCheck_1
and select Row then Rejects. Join the flow one of the new tLogRow. Connect the main to the other as shown:Now, when you run the job, you will see an additional reject row being output from the
tSchemaComplianceCheck
component.