Steps to analyze database tables - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-03-20
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

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:

Procedure

  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".
  4. Generating reports from these analyses and share the results among team members. These reports allow to compare current and historical statistics to determine the improvement or degradation of data.

What to do next

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

For more information on managing reports, see What are reports?.