Interview Questions

What is a Transformation? - ETL

ETL (extract, transform, and load) Testing Interview Questions


(Continued from previous question...)

69. What is a Transformation? - ETL

A transformation is a repository object that generates, modifies, or passes data. Transformations in a mapping represent the operations the PowerCenter Server performs on the data. Data passes into and out of transformations through ports that you link in a mapping or mapplet. Transformations can be active or passive. An active transformation can change the number of rows that pass through it. A passive transformation does not change the number of rows that pass through it.

(Continued on next question...)

Other Interview Questions