Analyzing tables in databases

Table analyses can range from simple table analyses to table analyses that uses SQL business rules or table analyses that detect anomalies in the table columns.

Using Talend Studio, you can better explore the quality of data in a database table through either:

• Creating a simple table analysis through analyzing all columns in the table using patterns.
• Adding data quality rules as indicators to table analysis.
• Detecting anomalies in column dependencies.
• Comparing a set of columns and creating groups of similar records using blocking and matching keys and/or survivorship rules.