Your Talend Studio enables you to:
- 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.