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.
public class AstLookupNode : AstSingleInTransformationNode, IBindableItem, IVulcanCollectionParent, IVulcanNotifyPropertyChanged, IPropertyChangeNotificationTarget, IGetJsonProvider, INamedNode, IScopeBoundary, IReferenceableItem, IFrameworkItem, INotifyPropertyChanged, IXObjectMappingProvider, IValidationInfo, IDataErrorInfo, INamedItem, IScopedNameIndexable, IDataflowItem
- Inheritance
-
System.ObjectAstLookupNode
- Derived
-
AstLookupNode
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. |