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

Documentation

Support Forums
What can we help you with?
Topics

Class AstLookupNode

The Lookup transformation combines data in input columns with data in columns in a reference data set. It is the data flow equivalent of a SQL join.

Namespace:
Varigence.Languages.Biml.Transformation
Assembly:
Biml.dll
C#
    public class AstLookupNode : 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
AstLookupNode
Derived
AstLookupNode
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

AstLookupNode(IFrameworkItem)

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

Properties

CacheMode

This value specifies whether caching is activated for rows that have no matching entries in the reference data source.

CacheModeDefaultValue

Gets the default value for the CacheMode property

CacheSize32

This value specifies the cache size in megabytes for 32-bit computers. The default value is 25 megabytes.

CacheSize32DefaultValue

Gets the default value for the CacheSize32 property

CacheSize64

This value specifies the cache size in megabytes for 64-bit computers. The default value is 25 megabytes.

CacheSize64DefaultValue

Gets the default value for the CacheSize64 property

Connection

This value specifies the name of the connection from which the lookup data set is loaded.

DefaultCodePage

This value specifies which default code page to use when the data source does not specify a default code page.

DefaultCodePageDefaultValue

Gets the default value for the DefaultCodePage property

EnableNoMatchOutputPath

Gets a value to indicate whether the no match output has been enabled

ErrorPath

Gets the error output path for this transformation

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 the collection of lookup input column mapping definitions.

MatchPath

Gets the match 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.

NoMatchBehavior

This value determines how the lookup component should behave when rows do not have matching entries in the reference data source. The default is to fail the component.

NoMatchBehaviorDefaultValue

Gets the default value for the NoMatchBehavior property

NoMatchCachePercentage

This value specifies what percentage of the cache is designated for rows that have no matching entries in the reference data source.

NoMatchCachePercentageDefaultValue

Gets the default value for the NoMatchCachePercentage property

NoMatchPath

Gets the no match output path for this transformation

Outputs

This is the collection of lookup output column mapping definitions.

ParameterizedQuery

This value specifies the parameterized query for the Lookup transformation.

Parameters

This is a collection of mappings from variables to parameters specified in the Query property.

Query

This is the query that will be used to obtain a data set from the Connection. The Lookup transformation will use this data set to map input and output columns.

TreatDuplicateKeysAsError

Determines whether duplicate keys in the reference data should be treated as errors when full cache mode is used.

TreatDuplicateKeysAsErrorDefaultValue

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

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

© Varigence