August 15, 2023

Scenario: Checking customer table against a given DQ rule to select customer records – Docs for ESB 6.x

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.

use_case-tmysqlinvalidrows-dq_rules1.png

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:


Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x