RollupCursor

An ETL rollup cursor.

Description

The rollup cursor constructs a row for each set of input rows that are equal over a set of grouping attributes. The rollup cursor is able to group rows only if the input provides the rows in sorted order: for this reason the grouping attributes must match a prefix of the input order-by specification.

Properties

attributeMapping : string

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

Aliasing is performed before the script is run.

Example

'((firstName firstName1) (homeAddress homeAddress1))

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 state))

batchSize : string

Expression specifying the number of records to include in each output 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 ScriptCursor node.

groupAttributes : string

The grouping attribute list. Must match a prefix of the input's order by specification.

Example

'(firstName (homeAddress city))

input : string

The input cursor name.

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

Content

• Sequence of:

  • GroupInitializer [0..1] - Each group is initialized by a custom script. In the script, the result row is available through a variable named "group".

  • GroupUpdater [0..1] - Each row of the group is processed by a script. In the script, the result row is available through a variable named "group" and the input row is available through a a variable named record.

  • GroupFinalizer [0..1] - Each group is finalized by a custom script. In the script, the result row is available through a variable named "group".

Parents

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