Aggregate

Namespace: Chimayo.Ssis.Ast.DataFlowApi

API for creating and manipulating Aggregate pipeline components

Functions and values

Function or valueDescription
add_aggregation value c
Signature: value:DfAggregateAggregation -> c:DfComponent -> DfComponent

Add an aggregation to the pipeline component

add_aggregations
Signature: DfAggregateAggregation list -> DfComponent -> DfComponent

Add multiple aggregations to the pipeline component

clear_aggregations
Signature: DfComponent -> DfComponent

Remove all aggregations from the pipeline component

connect_input
Signature: DfComponent -> string -> DfComponent -> DfComponent

Connects two pipeline components

connect_input_by_name
Signature: string -> string -> DfComponent -> DfComponent

Connects two pipeline components

create name adapters
Signature: name:string -> adapters:(DfComponent -> DfComponent) list -> DfComponent

Create a new instance of an Aggregate pipeline component and then apply a series of transformations

define_aggregation (...)
Signature: outputName:string -> (DfAggregateScaling * int option) -> columns:DfAggregateColumn list -> DfAggregateAggregation

Construct a new aggregation output

define_mapped_column (...)
Signature: name:string -> dataType:DfDataType -> sourceComponent:string -> sourceOutput:string -> sourceColumn:string -> logic:DfAggregateOperation -> DfAggregateColumn

Construct a new aggregation output column that operates over a source column

define_unmapped_column (...)
Signature: name:string -> dataType:DfDataType -> logic:DfAggregateOperation -> DfAggregateColumn

Construct a new aggregation output column that operates without a source column (i.e. count all)

disconnect_input
Signature: DfComponent -> DfComponent

Removes the connection, if any

get
Signature: DfComponent -> DfAggregateConfiguration

Alias for ingress

get_aggregations
Signature: DfComponent -> DfAggregateAggregation list

Get the aggregations

get_auto_extend_factor
Signature: DfComponent -> int

Get the auto extend factor

get_count_distinct_scaling
Signature: DfComponent -> DfAggregateScalingValue

Get the Count Distinct scaling

get_key_scaling
Signature: DfComponent -> DfAggregateScalingValue

Get the Key scaling

input_name
Signature: string

Defined name of the Aggregate input. Has to match SSIS internals.

set_auto_extend_factor value
Signature: value:int -> DfComponent -> DfComponent

Set the auto extend factor

set_count_distinct_scaling (arg1, arg2)
Signature: (DfAggregateScaling * int option) -> DfComponent -> DfComponent

Set the Count Distinct scaling

set_key_scaling (arg1, arg2)
Signature: (DfAggregateScaling * int option) -> DfComponent -> DfComponent

Set the Key scaling