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

Documentation

Support Forums
What can we help you with?
Topics

Class AstFuzzyLookupNode

The Fuzzy Lookup transformation looks up values in a reference data set by using fuzzy matching. That is, matches can be close rather than exact.

Namespace:
Varigence.Languages.Biml.Transformation
Assembly:
Biml.dll
C#
    public class AstFuzzyLookupNode : AstSingleInTransformationNode, IBindableItem, IVulcanCollectionParent, IVulcanNotifyPropertyChanged, IPropertyChangeNotificationTarget, IGetJsonProvider, INamedNode, IScopeBoundary, IReferenceableItem, IFrameworkItem, INotifyPropertyChanged, IXObjectMappingProvider, IValidationInfo, IDataErrorInfo, INamedItem, IScopedNameIndexable, IDataflowItem
    
  
Inheritance
System.Object
AstNode
AstNamedNode
AstScopeBoundaryNode
AstTransformationNode
AstSingleInTransformationNode
AstFuzzyLookupNode
Derived
AstFuzzyLookupNode
Implements

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

Constructors

AstFuzzyLookupNode(IFrameworkItem)

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

Properties

AutoPassThroughInputColumns

Specifies whether or not input columns to the Fuzzy Lookup node that lack an input mapping should be automatically set to passthrough.

AutoPassThroughInputColumnsDefaultValue

Gets the default value for the AutoPassThroughInputColumns property

Connection

This values specifies the OLE DB connection and database in which the fuzzy lookup reference table is located and where the fuzzy match index table is stored and accessed.

CopyReferenceTable

This value specifies whether a copy of the table specified in the ReferenceTable should be made for the fuzzy lookup.

CopyReferenceTableDefaultValue

Gets the default value for the CopyReferenceTable property

Delimiters

This value specifies which set of white-space and punctuation characters is used to separate fuzzy match fields into the words used for matching and scoring a fuzzy lookup.

DelimitersDefaultValue

Gets the default value for the Delimiters property

DropExistingIndex

This value specifies whether any existing indexes having the name specified in the MatchIndexName property should removed. The default is True.

DropExistingIndexDefaultValue

Gets the default value for the DropExistingIndex property

Exhaustive

This value specifies whether each input record is directly compared against every record in the reference table. This option is primarily intended for debugging purposes and should be used with care. This method is extremely slow unless the number of records in the reference table is very small. Note also that the entire reference table is loaded into main memory if this option is enabled.

ExhaustiveDefaultValue

Gets the default value for the Exhaustive property

FriendlyTypeName

Gets the friendly name of the type of this node

FriendlyTypeNameStatic

Gets the friendly name of the type of this node

Inputs

This is a collection of input column mapping definitions that determine the behavior of specific columns and their comparisons.

MatchIndexName

This value specifies the name of the fuzzy-match index table to be reused or the table name in which a newly generated fuzzy-match index table will be written.

MatchIndexNameDefaultValue

Gets the default value for the MatchIndexName property

MatchIndexOptions

This value indicates whether an existing fuzzy-match index table is reused or a new one is built. The new index table can be temporary, persisted, or persisted and maintained.

MatchIndexOptionsDefaultValue

Gets the default value for the MatchIndexOptions property

MaxMemoryUsage

This value specifies the maximum amount of memory (MB) that the current instance of the Fuzzy Lookup transformation can use. If 0 is given, then the transform dynamically adjusts memory usage based upon its requirements and available system memory.

MaxMemoryUsageDefaultValue

Gets the default value for the MaxMemoryUsage property

MaxOutputMatches

This value specifies which set of white-space and punctuation characters is used to separate fuzzy match fields into the words used for matching and scoring a fuzzy lookup.

MaxOutputMatchesDefaultValue

Gets the default value for the MaxOutputMatches property

MinSimilarity

This value specifies the minimum similarity score that is required in order for the transformation to return a match.

MinSimilarityDefaultValue

Gets the default value for the MinSimilarity property

OutputPath

Gets the output path for this transformation. This is the preferred output path and will automatically connect to any single-input transformation nodes that directly follow it in the Biml file.

Outputs

This is the collection of lookup output column mapping definitions.

ReferenceTable

This value specifies the name of the table or view against which incoming records are matched.

WarmCaches

This value specifies whether the error-tolerant index and the reference table are partially loaded into main memory before the Fuzzy Lookup transformation begins. This can greatly enhance performance if many input rows are to be processed.

WarmCachesDefaultValue

Gets the default value for the WarmCaches 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.

DefinedAstNodes()

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

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)
GetBimlChildFragment(CulturedStringBuilder, Int32)
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.

HasAnyBimlChildNodes()
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.

NotifyCollectionPropertyChanged(Object, String, NotifyCollectionChangedEventArgs)

Internal Biml framework method used to notify this node that the specified collection property value has changed.

ParseAttribute(XAttribute, ParserContext)
ParseChild(XElement, ParserContext)
StructureEquals(Object)

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

Validate(ValidationReporter)

Retrieves a collection of validation and diagnostic messages for the current node.

© Varigence