Aggregate Transformation:
Aggregate transformation is used for basic aggregation as in SQL such as count distinct, group by.
Advance Window
Providing the number of distinct values, exact or approximate, optimizes performance, because the transformation can preallocate an appropriate amount of memory to do its work.
SQL Server Quest 