Summary

In this chapter, you learned to insert code in your PDI transformations. Specifically, you learned what the JavaScript and the User Defined Java Class steps are, how to modify fields and add new fields to your dataset from inside your JavaScript or Java Class steps, and how to deal with unstructured input data. You also saw a list of the pros and cons of coding inside your transformations, as well as alternative ways to do things, such as avoiding writing code when possible.

If you feel confident with all you have learned until now, you are certainly ready to move on to the next chapter. There, you will learn to solve some sophisticated problems—such as normalizing data from pivoted tables—in a simple fashion.

Get Pentaho Data Integration Beginner's Guide 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.