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

Documentation

Support Forums
What can we help you with?
Topics

Adf Dataflow Lookup Transformation Element

API Type:
Varigence.Languages.Biml.DataFactory.AstAdfDataflowLookupTransformationNode
X-Ref:
  • Ast Adf Dataflow Lookup Transformation Node
  • Ast Adf Dataflow Single Output Transformation Base Node
  • Ast Adf Dataflow Transformation Base Node
  • Ast Adf Dataflow Component Base Node
  • Ast Scope Boundary Node

Attributes

AttributeAPI TypeDefaultDescription
InputStreamNameAstAdfDataflowOutputStreamNode 
A reference to a previous component's output stream. This is a required reference to an existing definiton.
LookupStreamNameAstAdfDataflowOutputStreamNode 
A reference to a previous component's output stream that will be referenced with the lookup transformation's input stream. This is a required reference to an existing definiton.
NameString 
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
BroadcastActionAdfDataflowLookupBroadcastActionAuto
Specifies how to handle broadcasting. When using Fixed, make sure you specify if you want the input or lookup stream to be broadcast.
BroadcastInputStreamBooleanFalse
Specifies whether to set the broadcast flag for the input stream.
BroadcastLookupStreamBooleanFalse
Specifies whether to set the broadcast flag for the lookup stream.
MatchMultipleRowsString"true"
Specifies whether to return all matched rows on a lookup.
MatchOnAdfDataflowLookupMatchOnActionAnyRow
Specifies matching behavior in the lookup stream. Only valid when MatchMultipleRows is set to false.
PartitionOptionAdfDataflowPartitionOptionCurrentPartitioning
Specifies how the user would like to handle partitioning inside of dataflow components.

Singleton Children

ChildAPI TypeDescription
<RoundRobin />AstAdfRoundRobinPartitionSettingsNodeSettings node for Round Robin partitioning in dataflow components.
<Hash />AstAdfHashPartitionSettingsNodeSettings node for Hash partitioning in dataflow components.
<DynamicRange />AstAdfDynamicRangePartitionSettingsNodeSettings node for Dynamic Range partitioning in dataflow components.
<FixedRange />AstAdfFixedRangePartitionSettingsNodeSettings node for Fixed Range partitioning in dataflow components.
<Key />AstAdfKeyPartitionSettingsNodeSettings node for Key partitioning in dataflow components.

Collection Children

ChildAPI TypeDescription
<LookupConditions>
    <Condition />
</LookupConditions>
AstAdfDataflowConditionNode
This is a collection of conditions to be used in the transformation. This is a required property
<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.
<SortConditions>
    <Condition />
</SortConditions>
AstAdfDataflowGenericSortColumnNode
This is a collection of conditions that will be used for sorting.

© Varigence