• PRODUCTS
  • SUPPORT
  • DOCS
  • PARTNERS
  • COMPANY
  • QUOTE
  • ACCOUNT
  • STORE
QUOTE

Documentation

Support Forums
What can we help you with?
Topics

Class 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.

Namespace:
Varigence.Languages.Biml.Task
Assembly:
Biml.dll
C#
    public class AstColumnPatternProfileRequestNode : AstDataProfileRequestNode, IBindableItem, IVulcanCollectionParent, IVulcanNotifyPropertyChanged, IPropertyChangeNotificationTarget, IGetJsonProvider, INamedNode, IReferenceableItem, IFrameworkItem, INotifyPropertyChanged, IXObjectMappingProvider, IValidationInfo, IDataErrorInfo, INamedItem, IScopedNameIndexable
    
  
Inheritance
System.Object
AstNode
AstNamedNode
AstDataProfileRequestNode
AstColumnPatternProfileRequestNode
Derived
AstColumnPatternProfileRequestNode
Implements

IBindableItem, Varigence.Utility.Collections.IVulcanCollectionParent, Varigence.Utility.ComponentModel.IVulcanNotifyPropertyChanged, Varigence.Utility.ComponentModel.IPropertyChangeNotificationTarget, IGetJsonProvider, INamedNode, IReferenceableItem, IFrameworkItem, System.ComponentModel.INotifyPropertyChanged, Varigence.Utility.Xml.IXObjectMappingProvider, IValidationInfo, System.ComponentModel.IDataErrorInfo, INamedItem, Varigence.Utility.Collections.IScopedNameIndexable,

Constructors

AstColumnPatternProfileRequestNode(IFrameworkItem)

Initializes a new instance of the AstColumnPatternProfileRequestNode class with the specified parent node.

Properties

CaseSensitive

This value specifies whether the patterns will be evaluated against column values using case sensitive comparisons.

CaseSensitiveDefaultValue

Gets the default value for the CaseSensitive property

Column

This value specifies the name of the column whose values will be profiled against the specified pattern.

ColumnDefaultValue

Gets the default value for the Column property

Delimiters

This value specifies the characters that will be replaced with spaces before tokenizing. The default include tab (\t), carriage return (\r), and line feed (\n).

DelimitersDefaultValue

Gets the default value for the Delimiters property

FriendlyTypeName

Gets the friendly name of the type of this node

FriendlyTypeNameStatic

Gets the friendly name of the type of this node

MaxNumberOfPatterns

This value specifies the maximum number of patterns that will be computed by the profile up to 100. The default is 10.

MaxNumberOfPatternsDefaultValue

Gets the default value for the MaxNumberOfPatterns property

PercentageDataCoverageDesired

This value specifies the percentage of data in the column that should be covered by the generated patterns from 0 to 100. The default is 95.

PercentageDataCoverageDesiredDefaultValue

Gets the default value for the PercentageDataCoverageDesired property

Symbols

This value specifies any symbols or punctuations that should be retained as part of the patterns. The default includes ,.;:-"'`~=&/@!?()<>[]{}|#*^%.

SymbolsDefaultValue

Gets the default value for the Symbols property

TagTable

This value specifies a direct connection to the tag table which will tag 2 string columns - Tag and Term.

TagTableConnection

This value specifies a direct reference to the ADO.NET connection that contains the tag table.

TagTableSchemaId

This value specifies the name of the schema that contains the tag table. This property is used in conjunction with TableId when the tag table cannot be referenced by the TagTable property, because it has not been modeled in the Biml project.

TagTableSchemaIdDefaultValue

Gets the default value for the TagTableSchemaId property

TagTableTableId

This value specifies the name of the tag table. This property is used in conjunction with TableId when the tag table cannot be referenced by the TagTable property, because it has not been modeled in the Biml project.

TagTableTableIdDefaultValue

Gets the default value for the TagTableTableId property

Methods

BindingScopeBoundaries()

Retrieves the permitted scope boundaries to bind references from this node.

BindReference(SymbolTable, String, Boolean, String, Int32, Boolean)
CopyFrom(IFrameworkItem, UnboundReferences)

Instructs the node to copy property values from the supplied node into itself. This method should only be used by the internal Biml framework.

Duplicate()

Creates a duplicate of the current node

Duplicate(Dictionary<IFrameworkItem, IFrameworkItem>)

Creates a duplicate of the current node with the scoped node mapping

Duplicate(IFrameworkItem)

Creates a duplicate of the current node with the specified parent item

Duplicate(IFrameworkItem, Dictionary<IFrameworkItem, IFrameworkItem>)

Creates a duplicate of the current node with the specified parent item and scoped node mapping

DuplicateHusk(IFrameworkItem)

Creates an empty object into which the values from the current node will be duplicated. This method should only be used by the internal Biml framework

DuplicateInto(IFrameworkItem, Dictionary<IFrameworkItem, IFrameworkItem>)

Copies the values from the current node into a husk object with the specified scoped node mapping. This method should only be used by the internal Biml framework

EmitXmlForAction(AstEnginePropertyAction)

Instructs the node to make changes to its underlying Biml code that correspond to the provided action. This method should only be used by the internal Biml framework.

EmitXmlForProperty(String, Int32)

Instructs the node to make changes to its underlying Biml code that correspond to the provided property and index. This method should only be used by the internal Biml framework.

ForceNull(String, Int32)

Internal method used by the compiler to make a propert value null when required by the binding framework.

GetAllItemsReferencedByDefinedSuccessors()

Builds a list of all items referenced by this node and its successors. Each tuple in the returned list represents a FrameworkItemReference. The first item is the ReferencingItem, the second item is the property name, and the third item is the ReferencedItem.

GetBimlAttributeFragment(CulturedStringBuilder)
GetBimlFragment(CulturedStringBuilder, Int32, Boolean)

Internal method used by the Biml engine to produce the XML code for the current object.

GetDefaultValue(String)

Retrieves the default value for the property with the name propertyName

GetDefaultValue<T>(String)

Retrieves the default value for the property with the name propertyName

GetJson(StringBuilder, ref Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean)

Generates a JavaScript Object Notation (JSON) representation of the current node

GetPotentialParentProperties()

Retrieves the reflection information for related properties of this node type.

GetPropertyValue(String)

Retrieves the current value for the property with the name propertyName

GetReflectionInfoFromXmlParsePath(String)

Retrieves the reflection information corresponding to the Xml parse path beginning at this node.

MergeFrom(IFrameworkItem, UnboundReferences, Boolean)

Instructs the node to merge property values from the supplied node into itself. This method should only be used by the internal Biml framework.

ParseAttribute(XAttribute, ParserContext)
StructureEquals(Object)

Compares this node to the provided object to determine if all defined children and references are equal.

© Varigence