A profile is the analysis of data quality based on the content and structure of data. A default profile is a profile that you create with default options. Use a default profile to get profile results without configuring all columns and options for a profile.
Create and run a default profile to analyze the quality of the data when you start a data quality project. When you create a default profile object, you select the data object and the data object columns that you want to analyze. A default profile skips the profile column and option configuration. The Analyst tool performs profiling on the live flat file for the flat file data object.
Story
HypoStores wants to incorporate data from the newly-acquired Los Angeles office into its data warehouse. Before the data can be incorporated into the data warehouse, it needs to be cleansed. You are the analyst who is responsible for assessing the quality of the data and passing the information on to the developer who is responsible for cleansing the data. You want to view the profile results quickly and get a basic idea of the data quality.
Objectives
In this lesson, you complete the following tasks:
Create and run a default profile for the LA_Customers flat file data object.
View the profile results.
Prerequisites
Before you start this lesson, verify the following prerequisite:
You have completed lessons 1 and 2 in this tutorial.
Timing
Set aside 5 to 10 minutes to complete this lesson.