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