Supported Transformations for Pushdown Optimization
When you configure pushdown optimization for the Teradata or Microsoft Azure SQL Data Warehouse database, the Secure Agent tries to push the configured transformation to the database.
The Secure Agent can push the following transformation logic to a Teradata or Microsoft Azure SQL Data Warehouse source or target:
Transformations | Teradata | Microsoft Azure SQL Data Warehouse |
|---|
Aggregator | Source, Full | Full |
Expression | Source, Full | Full |
Filter | Source, Full | Full |
Joiner | Source, Full | Full |
Sorter | Source, Full | Full |
Union | Source, Full | Full |
Router | Full | Full |