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

Documentation

Support Forums
What can we help you with?
Topics

Class AstDqsCleansingColumnMappingNode

The AstDqsCleansingColumnMappingNode type corresponds directly to a column mapping in the SQL Server Integration Services DQS Cleansing transformation.

Namespace:
Varigence.Languages.Biml.Transformation
Assembly:
Biml.dll
C#
    public class AstDqsCleansingColumnMappingNode : AstNode, IBindableItem, IGetJsonProvider, IFrameworkItem, IValidationInfo
    
  
Inheritance
System.Object
AstNode
AstDqsCleansingColumnMappingNode
Implements

Varigence.Utility.Collections.IVulcanCollectionParent, Varigence.Utility.ComponentModel.IVulcanNotifyPropertyChanged, Varigence.Utility.ComponentModel.IPropertyChangeNotificationTarget, System.ComponentModel.INotifyPropertyChanged, Varigence.Utility.Xml.IXObjectMappingProvider, System.ComponentModel.IDataErrorInfo,

Constructors

AstDqsCleansingColumnMappingNode(IFrameworkItem)

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

Fields

IsScopeImported

Properties

ColumnName

Specifies the name of the input column that should undergo correction via the rules specified in the DQS domain.

ColumnNameDefaultValue

Gets the default value for the ColumnName property

ConfidenceAlias

Specifies the name of the output column that should be created to store the confidence level for the correction applied to this column. If not specified, the ConfidenceAlias will default to the name of the input column followed by '_Confidence'. This value will be ignored if EnableConfidenceColumn is not set to true on the parent DQS Cleansing component.

ConfidenceAliasDefaultValue

Gets the default value for the ConfidenceAlias property

Domain

Specifies the name of the domain to use for correcting the values in this column.

DomainDefaultValue

Gets the default value for the Domain property

FriendlyTypeNameStatic

Gets the friendly name of the type of this node

OutputAlias

Specifies the name of the output column that should be created to store the corrected value for this column (or the original value if no correction was performed). If not specified, the OutputAlias will default to the name of the input column followed by '_Output'.

OutputAliasDefaultValue

Gets the default value for the OutputAlias property

ReasonAlias

Specifies the name of the output column that should be created to store the reason for the correction applied to this column. If not specified, the ReasonAlias will default to the name of the input column followed by '_Reason'. This value will be ignored if EnableReasonColumn is not set to true on the parent DQS Cleansing component.

ReasonAliasDefaultValue

Gets the default value for the ReasonAlias property

RenderedConfidenceAlias

Gets the name that will be used for the confidence alias when it is emitted into SSIS

RenderedOutputAlias

Gets the name that will be used for the output alias when it is emitted into SSIS

RenderedReasonAlias

Gets the name that will be used for the reason alias when it is emitted into SSIS

RenderedStatusAlias

Gets the name that will be used for the status alias when it is emitted into SSIS

SourceAlias

Specifies the name of the output column that should be created to store the original value for this column. If not specified, the SourceAlias will default to the name of the input column followed by '_Source'.

SourceAliasDefaultValue

Gets the default value for the SourceAlias property

StatusAlias

Specifies the name of the output column that should be created to store the status information for this column. If not specified, the StatusAlias will default to the name of the input column followed by '_Status'.

StatusAliasDefaultValue

Gets the default value for the StatusAlias property

Guid
Annotations

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.

ObjectTag

This property provides a general purpose storage mechanism for .NET objects to be associated with AstNode objects. It supplements the annotation system, which is intended for use with string-based metadata.

BimlFile

This value specifies the BimlFile in which the Biml code that defines AstNode resides.

ItemLabel

Gets a label that can be used to identify this node

ParentItem

This value specifies the parent of the current node. All nodes must have a valid parent in the Biml framework, except for the root node.

Methods

BindingScopeBoundaries()

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

Duplicate()

Creates a duplicate of the current node

Duplicate(IFrameworkItem)

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

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

GetSchemaLocalName()

Retrieves the local XML element name that corresponds to this node in Biml code.

StructureEquals(Object)

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

FirstChildOfType<TChild>()

Gets the first defined descendant node of the specified type

RemoveFromParent()

Removes this node definition from its parent

DefinedAstNodes()

Retrieves a collection of nodes that have been defined as direct children of the current node.

GetJson()

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

GetExternalJson()

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

GetJson(Boolean, Boolean, Boolean, Boolean, Boolean)

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

GetXObjectName()

Gets the fully qualified XML element name for this node in the code document.

FirstParent<TAstNode>()

Retrieves the first parent or ancestor node of the specified type

FirstParent<TAstNode>(Type)

Retrieves the first parent or ancestor node of the specified type with the specified custom attribute type

FirstThisOrParent<TAstNode>()

Retrieves the first parent or ancestor node of the specified type, including this node

IsDirectAncestor(IFrameworkItem)

Retrieves a value indicating whether the specified node is a direct ancestor of this node.

AncestorDistance(IFrameworkItem)

Retrieves the number of steps between this node and the nearest shared ancestor with the specified relative node.

FirstThisOrParent<TAstNode>(Type)

Retrieves the first parent or ancestor node (including this node) of the specified type with the specified custom attribute type

AllDefinedSuccessors()

Retrieves the collection of all nodes defined as a child of this or any successor node or the current node

AllDefinedSuccessors(Boolean)

Retrieves the collection of all nodes defined as a child of this or any successor node or optionally the current node

OnNotificationTargetPropertyChanged(String)
OnScopeBoundaryChanged(IScopeBoundary, IScopeBoundary)
AddParseableChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>)
RemoveParseableChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>)
AddScopeBoundaryChangedEventListener(IFrameworkItem, EventHandler<VulcanPropertyChangedEventArgs>)
RemoveScopeBoundaryChangedEventListener(IFrameworkItem, EventHandler<VulcanPropertyChangedEventArgs>)
AddParsePendingChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>)
RemoveParsePendingChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>)
AddFromTemplateChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>)
RemoveFromTemplateChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>)
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.

ParseSelf(XElement, ParserContext)
ParseChild(XElement, ParserContext)
ParseNameValueMapping(XElement)
BindReference(SymbolTable, String, Boolean, String, Int32, Boolean)
GetBimlChildFragment(CulturedStringBuilder, Int32)
HasAnyBimlChildNodes()

© Varigence