Thursday, August 08, 2013

SSIS Interview Questions: SSIS Multicast Task

Multicast transformation in SSIS which convert one input into multiple output which can be then used for different operations.
For example when we need to save the data in destination on the basis of two different look-up tables. The multicast can generate two outputs on which look-up operation can do simultaneously. Multicast is to increase database efficiency of package.

No comments:

Post a Comment