Effective in version 10.0, pushdown optimization is removed from the mapping optimizer level. To configure a mapping for pushdown optimization you must select a pushdown type in the mapping run-time properties.
Previously, the Data Integration Service applied pushdown optimization by default with the normal or full optimizer level.