Pushdown optimization to the source stops at the partition point <transformation name> because the source is not key-range partitioned.
The transformation uses a hash auto-keys partition, and the source is not key-range partitioned. When the partition is hash auto-keys, you must also configure the source for key-range partitioning.