Introduction to Profiles Overview
Create and run a profile to find the content, quality, and structure of data sources of an application, schema, or enterprise. The data source content includes value frequencies and datatypes. The data source structure includes keys and functional dependencies.
A profile is a repository object that finds and analyzes all data irregularities across data sources in the enterprise and hidden data problems that put data projects at risk. Running a profile on any data source in the enterprise gives you a good understanding of the strengths and weaknesses of its data and metadata.
You can use the Analyst tool and Developer tool to analyze the source data and metadata. Analysts and developers can use these tools to collaborate, identify data quality issues, and analyze data relationships. Based on your job role, you can use the capabilities of either the Analyst tool or Developer tool. The degree of profiling that you can perform differs based on which tool you use.
You can perform the following tasks in the Developer tool and Analyst tool:
- •Perform column profiling. The process includes discovering the number of unique values, null values, and data patterns in a column.
- •Add rules to column profiles.
- •Curate the inferred datatypes in the profile results.
- •Use scorecards to monitor data quality.
- •Generate a mapping from a profile.