Profile Requests

This collection defined the profiling operations that will be performed as part of this profiling task.

Permitted Collection Child Definitions

Child	API Type	Description
<CandidateKeyProfileRequest />	AstCandidateKeyProfileRequestNode	The AstCandidateKeyProfileRequestNode type corresponds directly to the candidate key data profile in the SQL Server Integration Services data profiling task, which will report which column(s) have unique values across rows and could consequently serve as keys.
<ColumnLengthDistributionProfileRequest />	AstColumnLengthDistributionProfileRequestNode	The AstColumnLengthDistributionProfileRequestNode type corresponds directly to the column length distribution data profile in the SQL Server Integration Services data profiling task, which will report length statistics for columns with character types.
<ColumnNullRatioProfileRequest />	AstColumnNullRatioProfileRequestNode	The AstColumnNullRatioProfileRequestNode type corresponds directly to the column null ratio data profile in the SQL Server Integration Services data profiling task, which will report the frequency of null values in nullable columns.
<ColumnPatternProfileRequest />	AstColumnPatternProfileRequestNode	The AstColumnPatternProfileRequestNode type corresponds directly to the column pattern data profile in the SQL Server Integration Services data profiling task, which will compute a collection of patterns that describe the values in a character-based column.
<ColumnStatisticsProfileRequest />	AstColumnStatisticsProfileRequestNode	The AstColumnStatisticsProfileRequestNode type corresponds directly to the column statistics data profile in the SQL Server Integration Services data profiling task, which will report aggregation statistics for numeric and date/time columns.
<ColumnValueDistributionProfileRequest />	AstColumnValueDistributionProfileRequestNode	The AstColumnValueDistributionRequestNode type corresponds directly to the column value distribution data profile in the SQL Server Integration Services data profiling task, which will report the number of occurences of each value for a given column.
<FunctionalDependencyProfileRequest />	AstFunctionalDependencyProfileRequestNode	The AstFunctionalDependencyProfileRequestNode type corresponds directly to the functional dependency data profile in the SQL Server Integration Services data profiling task, which will report whether all column values in one column have a 1:1 or 1:Many correspondance with a specified related column.
<ValueInclusionProfileRequest />	AstValueInclusionProfileRequestNode	The AstValueInclusionProfileRequestNode type corresponds directly to the value inclusion data profile in the SQL Server Integration Services data profiling task, which will report whether a proposed foreign key relationship between two tables would violate the foreign key constraint.