Pushdown optimization to source stops at the transformation <transformation name> because the mapping contains too many pipeline branches.
The mapping contains more than 64 two-way branches, 43 three-way branches, or 32 four-way branches. The Integration Service cannot generate SQL to push all the branches of the mapping to the database.