TableAggregation Transform

image_pdfimage_print

The aggregation settings allow data to be aggregated if several data sets from the source are to be written on the same target structure. This avoids a situation in which only one value from the source is written in the target system.

Aggregation functions

The following aggregation functions are available for TableAggregation, TableNormalization, and TableDenormalzation:

sum

Sum

min

Minimum

max

Maximum

avg

Average

count

Number of data entries written on one target position

first

The first data entry for one target position

last

The last data entry for one target position

group_concat

Concatenates all data entries with separator “,”

concat_distinct

Concatenates all distinct data entries with separator “,” (i.e. remove duplicate values)

selectivity

Estimates the selectivity (0-100) of a value. The value is defined as (100 * distinctCount / rowCount).

var_samp

The sample variance (square of the sample standard deviation)

stddev_samp

The sample standard deviation

var_pop

The population variance (square of the population standard deviation)

stddev_pop

The population standard deviation

none

No aggregation occurs; the last data set is written (overwriting).

 

image_pdfimage_print
Was this post helpful?
NoYes (-13 rating, 17 votes)
Loading...