Interview Questions

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