Profile and Analysis Types
Create a profile based on the type of analysis that you need to perform. The type of profile that you create corresponds to the type of analysis that you perform. For example, to perform a primary key analysis, you create a primary key profile.
You can create the following profiles to perform data analysis and discovery:
- Column Profile
- Analyzes data quality in selected columns in a table or file. You can define profiles for column analysis in the Analyst tool and Developer tool.
- Data Domain Discovery
- Discovers critical data characteristics within an enterprise. Data domain discovery identifies all the data domains associated with a column based on the column value or name. As part of the discovery process, you can manually create data rules and column name rules to verify whether a value or column name belongs to a data domain. You can then associate these rules when you create a data domain. You can also create data domains from the values and patterns in column profile results.
- Primary Key Profile
- Discovers primary key relationships between columns in a table or file. You can define profiles for primary key analysis in the Developer tool.
- Functional Dependency Profile
- Discovers functional dependencies between columns in a table or file. You can define profiles for functional dependency analysis in the Developer tool.
- Foreign Key Profile
- Discovers foreign key relationships between columns across multiple tables or multiple files. You can define profiles for foreign key analysis in the Developer tool.
- Join Profile
- Determines the degree of potential joins between columns in a data source or across multiple data sources. You can define profiles for join analysis in the Developer tool. The results appear in a Venn diagram.
- Overlap Discovery
- Determines the percentage of overlapping data in pairs of columns within a data source or multiple data sources. You can run the overlap discovery task from the editor in the Developer tool. You can validate the results and view them in a Venn diagram.
- Enterprise Discovery
- Runs multiple data discovery tasks on a large number of data sources and generates a consolidated summary of the profile results. Includes running a column profile, data domain discovery, and discovering primary key and foreign key relationships. Enterprise discovery automates the profile process for a large number of data sources.
Note: Changes that you make to profiles in the Analyst tool do not appear in the Developer tool until you refresh the Developer tool connection to the repository. Disconnect from the repository in the Developer tool and then reconnect to refresh the connection.