Chapter 6. Transforming Your Data by Coding
Whatever the transformation you need to do on your data, you have a good chance of finding PDI steps able to do the job. Despite that, it may be that there are not proper steps that serve your requirements. Or that an apparently minor transformation consumes a lot of steps linked in a very confusing arrangement that is difficult to test or understand. Putting colorful icons here and there and making notes to clarify a transformation can be practical to a point, but there are some situations like the ones described above where you inevitably will have to code.
This chapter explains how to insert code in your transformations. Specifically, you will learn:
- Inserting and testing JavaScript and Java code in your transformations
- Distinguishing situations where coding is the best option, from those where there are better alternatives
