Using Transformation executors

The Transformation Executor is a PDI step that allows you to execute a Transformation several times simulating a loop. The executor receives a dataset, and then executes the Transformation once for each row or a set of rows of the incoming dataset.

To understand how this works, we will build a very simple example. The inner Transformation, that is, the Transformation that will be executed iteratively, will receive a row with a student code and a student name and will create a file with some message for the student. The main Transformation will generate a list of students and then it will execute the inner Transformation once for every student, that is, once for every row.

Let's start by creating the Transformation ...

Get Learning Pentaho Data Integration 8 CE - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.