Setting up your Job - 7.3

MySQL validation
Version
7.3
Language
English
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Data Quality components > Validation components (Integration) > MySQL validation components
Data Quality and Preparation > Third-party systems > Data Quality components > Validation components (Integration) > MySQL validation components
Design and Development > Third-party systems > Data Quality components > Validation components (Integration) > MySQL validation components
Last publication date
2024-02-21

Procedure

  1. In the Repository tree view, expand in succession the Metadata and the DB Connections nodes where you have stored the input schemas and drop the relevant connection onto the design workspace.
    The Components dialog box displays.
  2. Select tMySQLInvalidRows from the list and click OK to close the dialog box.
    The tMySQLInvalidRows component displays on the workspace. The MySQL table used in this scenario is called customers. It holds the customers' customer_id, account_num, Iname, fname, country and Email columns.
  3. Drop tLogRow from the Palette onto the design workspace.
  4. Connect the two components together using the Main link.