Configuring Pushdown Optimization
Configure a mapping for Teradata source or full pushdown optimization in the Advanced Session Properties section.
Before you configure pushdown optimization, verify that the ODBC subtype is Other in the ODBC connection properties. If you connect from Linux, you must select Data Direct as the Driver Manager for Linux.
1. In the Schedule tab of the Mapping Configuration task, navigate to the Advanced Session Properties section.
2. Click Add to add a new session property.
3. From the Session Property Name list, select Pushdown Optimization.
4. From the Session Property Value list, select the required type of pushdown optimization.
The following image shows the pushdown optimization options:
