Iterating jobs and transformations

It may happen that you develop a job or a transformation to be executed several times, once for each different row of your data. Consider that you have to send a custom e-mail to a list of customers. You would build a job that, for a given customer, get the relevant data such as name or e-mail account and send the e-mail. You would then run the job manually several times, once for each customer. Instead of doing that, PDI allows you to execute the job automatically once for each customer in your list.

The same applies to transformations. If you have to execute the same transformation several times, once for each row of a set of data, you can do it by iterating the execution. The next Time for action tutorial ...

Get Pentaho 3.2 Data Integration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.