Explain the difference between active and passive transformation.

1.	Explain the difference between active and passive transformation.
Answer» Transformation can be classified into two types: Active transformation: In this, the number of rows that PASS from the source to the target is REDUCED as it eliminates the rows that do not meet the transformation condition. ADDITIONALLY, it can change the transaction history or ROW type. Passive transformation: Unlike active transformations, passive transformations do not eliminate the number of rows, so all rows pass from source to target without being modified. Additionally, it can MAINTAIN the transaction boundary and row type.

Answer»

Transformation can be classified into two types:

Active transformation: In this, the number of rows that PASS from the source to the target is REDUCED as it eliminates the rows that do not meet the transformation condition. ADDITIONALLY, it can change the transaction history or ROW type.
Passive transformation: Unlike active transformations, passive transformations do not eliminate the number of rows, so all rows pass from source to target without being modified. Additionally, it can MAINTAIN the transaction boundary and row type.

Discussion