Skip to main content

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!