Aggregate functions are used in dataflow Query transforms to perform aggregation on the grouped dataset.
You should be familiar with these functions as they are the same ones used in the SQL language:
To demonstrate the use of aggregate functions, we will perform a simple analysis of one of our tables. Import the
DimGeography table into the DWH datastore and create a new job with a single dataflow inside it using these steps:
DimGeographysource table and the
DimGeographytarget template table in a
STAGEdatabase to send the output to: