From the Profiling perspective of Talend Studio, you can examine the data available in different data sources and collect statistics and information about this data.
A typical sequence of profiling data using Talend Studio involves the following steps:
- Connecting to a data source including databases and delimited files in order to be able to access the tables and columns on which you want to define and execute analyses. For more information, see Creating connections to data sources.
- Defining any of the available data quality analyses including database content
analysis, column analysis, table analysis, redundancy analysis, correlation
analysis, etc. These analyses will carry out data profiling processes that will
define the content, structure and quality of highly complex data structures. The
analysis results will be displayed graphically next to each of the analysis editors,
or in more detail in the Analysis Results view.Note: While you can use all analyses types to profile data in databases, you can only use Column Analysis and Column Set Analysis to profile data in delimited files.