Relational Pushdown Optimization Best Practices for Developer Tool Mappings

Relational Pushdown Optimization Best Practices for Developer Tool Mappings

Mapping Example

Mapping Example

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:
The mapping contains four relational sources that are writing to one target. There are two Filter transformations, two Joiner transformations, and one Aggregator transformation.
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.

0 COMMENTS

We’d like to hear from you!