g_ETLPipelineSteps_RollupCursor

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 : stringThe 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 : stringThe 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 : stringExpression specifying the number of records to include in each output batch of data. Example
2000 and (* 20 100) are both valid values.
caption : stringString identifier for caption display in the UI.description : stringDescription of this ScriptCursor node.groupAttributes : stringThe grouping attribute list. Must match a prefix of the input's order by specification. Example
'(firstName (homeAddress city))
input : stringThe input cursor name.layout : stringThis 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 : stringThe name of the Rollup Cursor. Content

• Sequence of:

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

  • g_ETLPipelineSteps_RollupCursor_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.

  • g_ETLPipelineSteps_RollupCursor_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

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

• g_ETLPipelineSteps_RollupCursor_GroupInitializer
  Each group is initialized by a custom script. In the script, the result row is available through a variable named "group".

• g_ETLPipelineSteps_RollupCursor_GroupUpdater
  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.

• g_ETLPipelineSteps_RollupCursor_GroupFinalizer
  Each group is finalized by a custom script. In the script, the result row is available through a variable named "group".

Parent topic: g_ETLActivitySteps_ETLPipeline