Pushdown optimization stops at the Aggregator transformation <transformation name> because there is an upstream Aggregator transformation.
The Aggregator transformation is the second Aggregator transformation in the pipeline. The Integration Service cannot generate SQL statements for more than one Aggregator transformation in a pipeline. This occurs because the SQL generated for two consecutive Aggregator transformations results in a nested Aggregator function, which cannot be processed on the database.