On occasions, you have bunches of steps that do common tasks and you notice that you will need them in other contexts. That is, you would copy, paste, and reuse part of your work unless you work with sub-transformations.
Creating reusable Transformations
Creating and executing sub-transformations
Sub-transformations are, as the name suggests, Transformations inside Transformations.
The PDI proper name for a sub-transformation is mapping. However, as the word mapping is also used with other meanings in PDI—an example of that is the mapping of table fields with stream fields in a Table output step—we will use the more intuitive name sub-transformation.
A common reason to create sub-transformations is...
