Multicast Transformation
Multicast Transformation is used
to create multiple outputs from single input. We often have the situation where
we need to load the same data to multiple destinations. Multicast
Transformation is the transformation that takes single input of data and
creates multiple copies of data for us to use. Multicast Transformation is
synchronous transformation that mean it does not block the data before it
transmit to outputs.
Read: Multicast Transformation
Conditional Split Transformation
Conditional Split Transformation also accepts one input and
then generates multiple outputs depending upon the expressions those we write
to split the data.
In short, The both
transformations accept one input and give us multiple outputs but Multicast
Transformation gives us same output on each output what it received as input
But Conditional Split will split the data to multiple outputs depending upon
the expressions we wrote to divide the data into multiple outputs.
Multicast
|
Conditional Split
|
Replicate source data to multiple destinations so that different
logic can be applied to same source data
|
Distribute the source data into multiple destinations based on
conditions
|
Directs row to every output
|
Directs row to single output
|
Does not contain any error output
|
It has one error output
|
Do not require expressions
|
Expressions are used for specifying conditions
|
Do not have default output
|
It provides default output so that if a row matches no
expression it is directed to default output
|
This information is really useful for me to learn more at MSBI Online Training
ReplyDelete