Effective in version 9.6.1 HotFix 1, the Data Integration Service can apply the branch pruning optimization method. When the Data Integration Service applies the branch pruning method, it removes transformations that do not contribute any rows to the target in a mapping.
The Developer tool enables the branch pruning optimization method by default when you choose the normal or full optimizer level. You can disable branch pruning if the optimization does not increase performance by setting the optimizer level to minimal or none.
For more information, see the
Informatica Data Services 9.6.1 HotFix 1 Performance Tuning Guide
Effective in version 9.6.1 HotFix 1, the Data Integration Service can read constraints from relational sources, logical data objects, physical data objects, or virtual tables. A constraint is a conditional expression that the values on a data row must satisfy. When the Data Integration Service reads constraints, it might drop the rows that do not evaluate to TRUE for the data rows based on the optimization method applied.