The purpose of transformation modify the source data based on requirement of the target system.
In Transformation we have 2 ways to define the connected and unconnected Transformation,
An Active transformation can change the number of rows passing through it
Any transformation that splits or combines the data streams or reduce, expand or sort the data is an active transformation because it cannot be guaranteed that when the data passes through it, the number of rows and their position in the data stream are always unchanged
A Passive transformation does not change the number of rows passing through it, maintains the transaction boundary and position of the rows passing through it
Active Transformation ( connected and unconnected )
Transaction control Transformation
Take the opportunity to connect and share this video with your friends and family if you find it useful.
Keywords: IICS, Transformation, What is mean by transformation, Types of transformation, Active transformation, Passive transformation, What is mean by active transformation, What is mean by passive transformation, Types of transformation in ETL