For example, a mapping contains a Joiner transformation with the join condition "A=B" and a Filter transformation with the filter condition "A>5." The Data Integration Service might be able to add "B>5" to the join condition and move the Filter transformation closer to the source.

The global predicate optimization method applies predicate expressions more effectively than the predicate optimization method. The global predicate optimization method determines whether it can simplify or rewrite the expressions to increase mapping performance. It also attempts to apply predicate expressions as early as possible in the mapping to improve mapping performance.

The global predicate optimization method infers filters and pushes them closer to the source when the mapping contains nested joiners or branches with filters on each branch. When the Data Integration Service uses the global predicate optimization method, it splits the filters, moves the filters closer to the source, or removes the filters in a mapping.