Functional Dependency Profile Request Element
X-Ref:
- Ast Functional Dependency Profile Request Node
- Ast Data Profile Request Node
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| ConnectionName | AstAdoNetConnectionNode | This value specifies the connection that will be used to access the target table. This is a required reference to an existing definiton. | |
| Name | String | Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property | |
| DependentColumn | String | This value specifies the name of the column whose value should be determined by the DeterminantColumns. | |
| FDStrengthThreshold | Double | 0.95 | This value specifies the threshold for functional dependency strength that must be satisfied before functional dependency strength is reported. This value must be specified in conjunction with a ThresholdSetting of 'Specified'. The default is 0.95. |
| MaxNumberOfViolations | Int32 | 100 | This value specifies the maximum number of functional dependency violations to report. If ThresholdSetting is 'Exact', then this property is ignored (as it is implied to be 0). The default is 100. |
| SchemaId | String | This value specifies the name of the schema that contains the table that will examined by the data profile task. This property is used in conjunction with TableId when the table cannot be referenced by the Table property, because it has not been modeled in the Biml project. | |
| TableName | AstTableNode | This value specifies a direct connection to the table that will examined by the data profile task. This references an existing definiton. | |
| TableId | String | This value specifies the name of the table that will examined by the data profile task. This property is used in conjunction with SchemaId when the table cannot be referenced by the Table property, because it has not been modeled in the Biml project. | |
| ThresholdSetting | ProfileRequestThresholdSetting | Specified | This value specifies the conditions under which the strength of a given functional dependency will be reported. The default is 'Specified'. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |
| <DeterminantColumns> <Column /> </DeterminantColumns> | String | This is a collection of strings that determine the names of the determinant columns that should determine the value of the DependentColumn. |