Data Profiling Task Editor (Profile Requests Page)
Use the Profile Requests Page of the Data Profiling Task Editor to select and configure the profiles that you want to compute. In a single Data Profiling task, you can compute multiple profiles for multiple columns or combinations of columns in multiple tables or views.
For more information about how to use the Data Profiling Task, see Setting Up the Data Profiling Task. For more information about how to use the Data Profile Viewer to analyze the output of the Data Profiling Task, see Viewing Profile Output in the Data Profile Viewer.
To open the Profile Requests page of the Data Profiling Task Editor
In Business Intelligence Development Studio, open the Integration Services package that has the Data Profiling task.
On the Control Flow tab, double-click the Data Profiling task.
In the Data Profiling Task Editor, click Profile Requests.
The requests pane is the pane that appears at the top of the page. This pane lists all the profiles that have been configured for the current Data Profiling task. If no profiles have been configured, the requests pane is empty. To add a new profile, click in an empty area under the Profile Type column and select a profile type from the list. To configure a profile, select the profile in the requests pane, and then set the profile's properties in the Request Properties pane.
Requests Pane Options
The request pane has the following options:
Requests Pane Columns
The columns that the requests pane displays depend on the View that you have selected:
If you select to view All Requests, the requests pane has two columns: Profile Type and Request ID.
If you select to view one of the five column profiles, the request pane has four columns: Profile Type, Table or View, Column, and Request ID.
If you select to view a Candidate Key profile, the request pane has four columns: Profile Type, Table or View, Key Columns, and Request ID.
If you select to view a Functional Dependency profile, the request pane has five columns: Profile Type, Table or View, Determinant Columns, Dependent Column, and Request ID.
If you select to view a Value Inclusion Profile, the request pane has six columns: Profile Type, Subset Side Table or View, Superset Side Table or View, Subset Side Columns, Superset Side Columns, and Request ID.
The following sections describe each of those columns.
Columns Common to All Views
Columns Common to All Individual Profiles
Columns Common to the Five Individual Column Profiles
Columns Specific to the Candidate Key Profile
Columns Specific to the Functional Dependency Profile
Columns Specific to the Value Inclusion Profile
The Request Properties pane appears underneath the requests pane. This pane displays the options for the profile that you have selected in the requests pane.
After you select a Profile Type, you must select the Request ID field to see the properties for the profile request in the Request Properties pane.
These options vary based on the selected profile. For information about the options for individual profile types, see the following topics: