Pushdown Optimization (PDO) is the process of pushing transformation logic to the source or target database by Secure Agent. When you run a session configured for PDO, the Secure Agent analyzes the mapping and transformations to determine the transformation logic it can push to database.
In case of Full PDO, the source and target databases must be in the same relational database management system. The Secure Agent analyzes the mapping from the source to the target or until it reaches a downstream transformation it cannot push to the target database.
This document describes how to configure Azure SQL Data Warehouse ODBC Connection on Windows and Linux operating systems. It also explains how you can create an ODBC connection and case studies and best practices while using Full PDO.
ASK INFAPreview
