✍ Kashif M
Trends

Sunday, 16 February 2014


Why union transformation is an active transformation


By on February 16, 2014



Union transformation has an option in its properties as ‘IS_ACTIVE’ if we enable this option it is active transformation else it will be passive transformation.


Union is an active transformation because it combines two or more data streams into one. Though the total number of rows passing into the Union is the same as the total number of rows passing out of it, and the sequence of rows from any given input stream is preserved in the output, the positions of the rows are not preserved, i.e. row number 1 from input stream 1 might not be row number 1 in the output stream. Union does not even guarantee that the output is repeatable.

Kashif
mkashu: Why union transformation is an active transformation
Review : Kashif | Kashif
Update: February 16, 2014 | Rating: 4.5

Comment for "Why union transformation is an active transformation"

0 comments

Post a Comment

Blog Archive