Checking customer table against a given DQ rule to select customer records

This scenario applies only to Talend Data Management Platform, Talend Big Data Platform, Talend Real-Time Big Data Platform, Talend MDM Platform, Talend Data Services Platform, Talend MDM Platform and Talend Data Fabric.

For more technologies supported by Talend, see Talend components.

This example is a three-component Job that checks a MySQL customer table against a given data quality rule so as to query specific customer records.

The components used in the Job are:

• tMysqlConnection: this component creates the connection to the MySQL database so that the other components can reuse it.

• tMySQLInvalidRows: this component reuses the connection created by tMysqlConnection and query the customer records against the given data quality rule.

• tLogRow: this component presents the result of running this Job.

  Information noteRemember: The connection components, including tMysqlConnection and tMySQLInvalidRows, have been regrouped into the tDBConnection component. They are automatically converted into this component when you place them on the workspace.