Pushdown optimization to the source stops at the partition point <transformation name> because a downstream Joiner transformation is not properly partitioned on the join key.
You configured a join condition for the upstream Joiner transformation that is different from the partition key specified for the key-range partition. The join condition and partition key must match.
Configure the join condition and the key-range partition to match.