Pushdown optimization stops at the Source Qualifier transformation <transformation name> because it contains an SQL override with Informatica join syntax.
The SQL override contains Informatica join syntax. Because the Integration Service creates a view to process the SQL override, the syntax must be compatible with the source database.
Use source database syntax when you write the SQL override.