Announcement: New Design for docs.informatica.com!
We have updated the look and feel of docs.informatica.com. To load the latest design, press CTRL-F5 to clear the pages you previously cached on our site, or simply restart your browser.
Use the following rules and guidelines for pushdown optimization to a Netezza database:
You must enable the Pre 85 Timestamp Compatibility session property to perform target-side pushdown optimization on Netezza if the Netezza database table contains a date, time, or timestamp column. If you disable the option, the Integration Service processes the target operation.
You cannot push transformation logic to Netezza for a passive connected or unconnected Lookup transformation.