Pushdown Optimization

Effective in version 9.5.0, you can disable creation of temporary views for pushdown optimization to Teradata when the Source Qualifier transformation contains source filter, user defined joins, or SQL override.

Previously, pushdown optimization on Teradata database would create and drop views when you have source filter, user defined joins, or SQL override at the Source Qualifier transformation.