Pushdown optimization stops at the Joiner transformation <transformation name> because an input pipeline contains an Aggregator transformation.
An Aggregator transformation exists in an input pipeline. The database must perform join operations before aggregation operations, so the Integration Service cannot generate an SQL statement for a Joiner transformation that is downstream from an Aggregator transformation.