Скачать или смотреть Aggregate Transformation Tutorial in Astera Centerprise

The Aggregate transformation in Astera Centerprise provides the functionality to create aggregations of your dataset, using aggregate functions such as Sum, Count, First, Last, Min, Max, Average, Var, or StDev. The dataset can be split into groups so that the aggregate value(s) can be generated for the group instead of the whole dataset. For example, calculate product count by month of the year, or get average sales price by region and year.
The Aggregate transformation can be applied to unsorted data or data sorted by group by values. When applied to an input stream that is sorted on group by fields, Aggregate Transformation performs substantially better and consumes very little memory. On the other hand, when applied to unsorted data, Aggregate Transformation may consume substantial memory resources for large data sets and may slow down the performance of the server.

In this video, we will cover:
Using the Aggregate transformation in Astera Centerprise
Exploring various aggregate functions
Grouping the dataset by a key field
Finding the minimum and maximum values in different product categories
Finding the total price of each category
Finding the total number of products in a category
Various data sorting options in the Aggerate properties