Sorted input reduces the amount of data cached during the session and improves the performance of Aggregator. There are chances that you use sorted input in Aggregator still the workflow takes a long time to execute. To avoid such scenarios keep in mind the below points in the mapping or session.
- Don’t use incremental aggregation in session.
- Don’t use nested aggregate functions inside aggregate expressions.
- Also the source data should not be data driven