g_ETLPipelineSteps_MergeJoinCursor

MergeJoinCursor

An ETL MergeJoin cursor.

Properties

attributes : string

The list of attributes that the cursor passes on to the next step in the pipeline.

Simple attributes or fields of complex attributes can be specified.

Example

A list of simple attributes: '(firstName lastName)
A list with a complex attribute: '(firstName (homeAddress city))

batchSize : string

Expression specifying the number of records to include in each batch of data.

Example

2000 and (* 20 100) are both valid values.

caption : string

String identifier for caption display in the UI.

description : string

Description of this MergeJoinCursor node.

joinAttributes : string

The join attribute pairs.

Example

'((firstName firstName2) ((homeAddress city) (homeAddress2 city))).

layout : string

This attribute captures the UI layout information for rendering the model in the editor. The values change as users moves the element in the editor.

leftAttributeMapping : string

The attribute mapping for the left input attribute names. May be unspecified or null.

Example

'((firstName firstName1) (homeAddress homeAddress1))

leftInput : string

The left input cursor name.

name : string

The name of the MergeJoin Cursor.

rightAttributeMapping : string

The attribute mapping for the right input attribute names. May be unspecified or null.

Example

'((firstName firstName1) (homeAddress homeAddress1))

rightInput : string

The right input cursor name.

type

The join type. One of: inner, left, or full.

Valid values based on“string”.
inner
left
full

Parents

• g_ETLActivitySteps_ETLPipeline - Pipelines gather and group cursors and commands together into related units, becoming the defining blocks of your ETL activities.

Parent topic: g_ETLActivitySteps_ETLPipeline