Consider a mapping with multiple relational sources writing to one relational target. The mapping contains Filter transformations, Joiner transformations, and an Aggregator transformation.
The following image shows the mapping:
When full pushdown optimization was configured for the mapping, the mapping took a few seconds to run. With default mapping configuration, the mapping took one hour to run.