Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Do Full pushdown Optimization with Azure DataWarehouseV2 ODBC connector in IICS
Solution
Azure DataWarehouseV2 Connector supports Full pushdown optimization with an ODBC connection that uses Sql Server ODBC drivers

Add the Pushdown Optimization property under Advanced Session Properties tab when you create a Mapping Configuration task and select Full or To Source in the Session Property Value field. 

Note: You need to apply EBF CCON-10572 to use Pushdown Optimization option. Contact Informatica Global Customer Support to install the Informatica EBF CCON-10572.

To do full PDO with update option you have to set "Allow temporary view for Pushdown"=YES in the advance session properties of MCT task.

Azure_PDO.png
More Information
​Add the Pushdown Optimization property under Advanced Session Properties tab when you create a Mapping Configuration task and select Full in the Session Property Value field​
Reference
Applies To
Product: Cloud Data Integration
Problem Type: Connectivity
User Type: Architect
Project Phase: Configure
Product Version:
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:11/11/2019 5:49 AMID:526310
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)