Pushdown optimization to the source stops at the partition point <transformation name> because the source contains a user-defined filter on a per-partition basis.
You added a user-defined distinct filter condition at the Source Qualifier transformation. Two or more partitions use a different filter condition. The Integration Service cannot push transformation logic to the source when you use a distinct user-defined filter.