Rank T/R cannot be pushed
Transaction control T/R
Sorted aggregation.
Procedure:
1. Design a mapping with filter, rank, and expression T/R.
2. Create a session --> Double click the session select properties tab.
Attribute Value
Pushdown optimization Full
3. Select the mapping tab --> set reader, writer connection with target load type normal.
4. Click apply --> click ok --> save the session.
5. Create & start the workflow.
Pushdown Optimization Viewer:-
Double click the session --> Select the mapping tab from the left window --> select pushdown optimization.
