Pushdown optimization stops at the Source Qualifier transformation <transformation name> because it contains a user-defined join with Informatica join syntax.
The user-defined join contains Informatica join syntax. Because the Integration Service pushes the transformation logic for the join to the source database, the syntax must be compatible with the source database.
Use source database syntax when you write the user-defined join.