SSIS Tutorial | Aggregate Transformation

The SSIS Aggregate Transformation groups the data and applies aggregate functions on the remaining columns. It has two modes
* Basic: It returns a single output.
* Advanced: It returns multiple outputs.

The following are the available functions in SSIS aggregate transformation.
1. Group By: Groups the columns.
2. Count: Counts the value.
3. Count distinct: It won’t count duplicates.
4. Sum: Addition of column values.
5. Average: Calculate or finds the average.
6. Minimum
7. Maximum

Chapters
00:00 - SSIS Aggregate Transformation Basic Mode
04:18 - Aggregate Transformation Advanced Mode

#SSISTutorial #SSIS #AggregateTransformation #SSISAggregateTransformation

More Info:
Basic: https://www.tutorialgateway.org/aggre...
Advanced: https://www.tutorialgateway.org/aggre...

Playlists
SSIS: SSIS Tutorial
SSRS: SSRS Tutorial
Power BI: Power BI Tutorial
Tableau: Tableau Tutorial

Websites:
SSIS: https://www.tutorialgateway.org/ssis/
SSRS: https://www.tutorialgateway.org/ssrs/
Power BI: https://www.tutorialgateway.org/power...
Tableau: https://www.tutorialgateway.org/tableau/

Social Media
Facebook: Facebook: tutorialgateway
Twitter : Twitter: tutorialgateway
Youtube: @tutorialgateway

• #education
• #ssis_aggregate_transformation
• #aggregate_transformation_in_ssis
• #ssis_aggregate_transformation_basic_mode
• #ssis_aggregate_transformation_advanced_mode
• #ssis_aggregate
• #sql_integration_services_aggregate_transformation