Analyzing tables in databases - Cloud

Talend Cloud API Services Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
task
Design and Development
EnrichPlatform
Talend Management Console
Talend Studio

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.