Lookup Element
X-Ref:
- Ast Lookup Node
- Ast Single In Transformation Node
- Ast Transformation Node
- Ast Scope Boundary Node
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| Name | String | Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property | |
| CacheMode | CacheMode | Full | This value specifies whether caching is activated for rows that have no matching entries in the reference data source. |
| CacheSize32 | Int32 | 25 | This value specifies the cache size in megabytes for 32-bit computers. The default value is 25 megabytes. |
| CacheSize64 | Int32 | 25 | This value specifies the cache size in megabytes for 64-bit computers. The default value is 25 megabytes. |
| OleDbConnectionName | AstConnectionBaseNode | This value specifies the name of the connection from which the lookup data set is loaded. This references an existing definiton. | |
| DefaultCodePage | Int32 | 0 | This value specifies which default code page to use when the data source does not specify a default code page. |
| LocaleId | Language | Inherited | This value specifies which locale is used by the dataflow task. |
| NoMatchBehavior | LookupNoMatchBehavior | FailComponent | 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. |
| NoMatchCachePercentage | Int32 | 0 | This value specifies what percentage of the cache is designated for rows that have no matching entries in the reference data source. |
| TreatDuplicateKeysAsError | Boolean | False | Determines whether duplicate keys in the reference data should be treated as errors when full cache mode is used. |
| ValidateExternalMetadata | Boolean | true | This value specifies whether the data flow transformation is validated against columns that originated in external data sources. When server assets such as tables and stored procedures are created during processing, ValidateExternalMetadata is normally set to False, which prevents validation from completing at compile time. |
Singleton Children
| Child | API Type | Description |
|---|---|---|
| <ErrorHandling /> | AstComponentErrorHandlingNode | Specifies the error handling defaults to apply to an entire component |
| <InputPath /> | AstDataflowInputPathNode | AstDataflowInputPathNode is used to model input paths in a SQL Server Integration Services dataflow task. Connections are made by referencing an appropriate output path. |
| <ParameterizedQuery /> | AstDirectResourceNode | The AstDirectResourceNode type provides the facility to directly input text data for use in the referencing Biml object. |
| <DirectInput /> | AstDirectResourceNode | The AstDirectResourceNode type provides the facility to directly input text data for use in the referencing Biml object. |
| <TableInput /> | AstTableResourceNode | The AstTableResourceNode type is used for creating references to a table that has been modeled in the Biml project. |
| <ExternalTableInput /> | AstUnmanagedTableResourceNode | The AstUnmanagedTableResourceNode type is used for creating references to a table stored in an existing relational database that has not been modeled in the Biml project. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | 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. |
| <DataflowOverrides> Multiple Choices... </DataflowOverrides> | AstDataflowOverrideNode | Provides a collection of objects to override properties of the component, its input paths, its output paths, and its consituent dataflow columns. |
| <Inputs> <Column /> </Inputs> | AstDataflowColumnMappingNode | This is the collection of lookup input column mapping definitions. |
| <Outputs> <Column /> </Outputs> | AstLookupOutputColumnMappingNode | This is the collection of lookup output column mapping definitions. |
| <Parameters> <Parameter /> </Parameters> | AstDataflowColumnMappingNode | This is a collection of mappings from variables to parameters specified in the Query property. |