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.
For more information, see Creating a simple table analysis (Column Set Analysis).
Adding data quality rules as indicators to table analysis. For more information, see Creating a table analysis with SQL business rules.
Detecting anomalies in column dependencies. For more information, see Detecting anomalies in columns (Functional Dependency Analysis).
Comparing a set of columns and creating groups of similar records
using blocking and matching keys and/or survivorship rules.
For more information, see Analyzing duplicates.