Scenario: Checking customer table against a given DQ rule to select customer
records
This scenario applies only to a subscription-based Talend Platform solution or Talend Data Fabric.
This scenario is a three-component Job that checks a MySQL customer table against a
given data quality rule so as to query specific customer records.

These components used in the Job are:
-
tMysqlConnection: this component creates the
connection to the MySQL database of interest so that the other components can
reuse it. -
tMySQLInvalidRows: this component reuses the
connection created by tMysqlConnection and
query the customer records of interest against the given data quality
rule. -
tLogRow: this component presents the result
of running this Job.
To replicate this scenario, proceed as illustrated in the following sections: