Cost-Based Optimization

Effective in version 9.5, the Data Integration Service cost-based optimization method can use profiling statistics or database statistics to estimate the number or rows that pass through a transformation.

Previously, the Data Integration Service could use database statistics to estimate the number of rows that pass through a transformation.