What this book covers

Chapter 1, Getting Started with PDI, presents the tool. This chapter includes instructions for installing PDI and gives you the opportunity to explore and configure the graphical designer (Spoon).

Chapter 2, Getting Familiar with Spoon, explains the fundamentals of working with Spoon by designing, debugging, and testing a transformation.

Chapter 3, Extracting Data, discusses getting and combining data from different sources. In particular, this chapter explains how to get data from files and databases.

Chapter 4, Transforming Data, explains how to transform data in many ways. Also, it explains how to get system information and predefined variables to be used as part of the data flow.

Chapter 5, Loading Data, explains how to save the output of transformations into files and databases. In addition, it explains how to load data into a datamart.

Chapter 6, Orchestrating your Work, shows how to organize your work through simple PDI jobs. You will learn how to use jobs to sequence tasks, deal with files, send emails, run DDL, and to carry out other useful tasks.