Steps to analyze database tables - 7.3

Talend Open Studio User Guide

Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Studio
Design and Development
Last publication date
Available in...

Open Studio for Data Quality

About this task

You can examine the data available in single tables of a database and collect information and statistics about this data.

The sequence of profiling data in one or multiple tables may involve the following steps:


  1. Defining one or more tables on which to carry out data profiling processes that will define the content, structure, and quality of the data included in the table.
  2. Creating SQL business rules based on WHERE clauses and add them as indicators to table analyses.
  3. Creating column functional dependencies analyses to detect anomalies in the column dependencies of the defined table through defining columns as either "determinant" or "dependent".

What to do next

Check Analyzing tables in databases for information about the different options to analyze a table.