g_ETLPipelineSteps_UnionAllCursor

UnionAllCursor

An ETL UnionAll 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.

This value is ignored if no orderBy is specified.

Example

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

caption : string

String identifier for caption display in the UI.

description : string

Description of this UnionAllCursor node.

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.

name : string

The name of the UnionAll Cursor.

orderBy : string

The order-by list for the resulting records. (Optional)

The order-by list specified here must be a prefix of the order-by list of each input. Specifying an order-by list forces the UnionAll cursor to interleave records from the inputs to maintain the order.

Content

• Sequence of:

  • g_ETLPipelineSteps_UnionAllCursor_Inputs [0..1]

Parents

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

• g_ETLPipelineSteps_UnionAllCursor_Inputs
  

Parent topic: g_ETLActivitySteps_ETLPipeline