Limitations of Pushdown optimization.
- Source and Target and Lookups must be in same database server for full Pushdown.
- Expressions which are not supported by databases like data_diff () cannot be used in Expression transformations, the solution is to used SQL override.
- Variable Ports in Expression transformation is not allowed, the solution is to use SQL override.
- When Using SQL override, you need to Allow temporary view for pushdown in session properties.
- When Using Sequencer you need to Allow temporary sequence for pushdown in session properties.
- Sorter and Sequence cannot be used in the same pipeline.
- The unconnected lookup should have return port else you will get otplkp.cpp error while doing a preview of data.
- If you use pushdown optimization, you cannot override the ORDER BY clause or suppress the generated ORDER BY clause with a comment notation.
