Sadly: Full #pushdown optimization stops at the target [target] because #update on #Teradata is not supported in the presence of the joiner or lookup. - Informatica #PowerCenter #PDO Solution: replace Joiner Transformations with #sql overrides in Source Qualifiers and it will work. Some say Update Strategy doesn't work with #PDO but actually it does: both DD_INSERT and DD_UPDATE 👍 When #insert is done on target you can use Joiner though. #ETL