Big Data Platform
Cloud API Services Platform
Cloud Big Data Platform
Cloud Data Fabric
Cloud Data Management Platform
Data Management Platform
Data Services 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:
- 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.
- Creating SQL business rules based on WHERE clauses and add them as indicators to table analyses.
- Creating column functional dependencies analyses to detect anomalies in the column dependencies of the defined table through defining columns as either "determinant" or "dependent".
- 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.