Active Transformation: the transformation that change the no. of rows in the Target.
Source (100 rows) ---> Active Transformation ---> Target (< or > 100 rows)Passive Transformation: the transformation that does not change the
no. of rows in the Target.
Source (100 rows) ---> Passive Transformation ---> Target (100 rows)
Union Transformation: in Union Transformation we may combine the data from two (or) more sources. Assume Table-1 contains '10' rows and Table-2 contains '20' rows. If we combine the rows of Table-1 and Table-2 we will get a total of '30' rows in the Target. So it is definetly an Active Transformation.
Source (100 rows) ---> Active Transformation ---> Target (< or > 100 rows)Passive Transformation: the transformation that does not change the
no. of rows in the Target.
Source (100 rows) ---> Passive Transformation ---> Target (100 rows)
Union Transformation: in Union Transformation we may combine the data from two (or) more sources. Assume Table-1 contains '10' rows and Table-2 contains '20' rows. If we combine the rows of Table-1 and Table-2 we will get a total of '30' rows in the Target. So it is definetly an Active Transformation.
No comments:
Post a Comment