What are active and passive transformations? - ETL
ETL (extract, transform, and load) Testing Interview Questions
(Continued from previous question...)
54.
What are active and passive transformations? - ETL
In an active transformation, the number of rows that is created as output can be changed once a transformation has occurred. This does not happen during a passive transformation; the information passes through the same number given to it as input.
Explain the following: mapping, session, worklet, workflow, and mapplet.
Mapping is the movement of data from the source to the destination.
Session is the parameters set to instruct the data on during the above movement.
Worklet represents a specific set of tasks given.
A workflow is a set of instructions that tell the server how to execute tasks.
A mapplet creates or arranges sets of transformation.
(Continued on next question...)
Other Interview Questions
|