Validating data

Talend Studio lets you:

• Analyze the content of one or multiple database columns against regular expressions, and then generate a ready-to-use Job on the analysis results to recuperate valid and invalid rows.
• Analyze the content of a database table against an SQL business rule, and then generate a ready-to-use Job on the analysis results to recuperate valid and invalid rows.
• Analyze the content of a database table against regular expressions, and then generate a ready-to-use Job on the analysis results to recuperate the matching and non-matching rows and write them in output files or databases.
• Use several data quality components to check data in databases against regular expressions, matching rules or reference data sources.