In the previous chapters, you learned the basics of transforming data. This chapter expands your knowledge by teaching you a variety of essential features. Besides exploring new PDI steps for data manipulation, this chapter explains in detail a key resource in every process: the Select values step. The chapter also teaches you how to get system information and predefined variables to be used as part of the data flow. A special section is devoted to reading and writing XML and JSON structures.
In this chapter, you will learn about the following topics:
- New ways to transform data
- Understanding the Select values step and its different uses
- Getting system information and predefined variables
- Manipulating XML and JSON structures
