...
- Install Pentaho Data Integration and get familiar with the graphical designer---Spoon
- Get data from simple input sources, preview, and send it back in any of the common output formats
- Perform both simple and complex transformation on your data and manipulate the flow of data in different ways
- Explore the various PDI options to validate data and to handle errors
- Solve real-world problems by manipulating the flow of data by combining or splitting it
- Solve sophisticated problems such as normalizing data from pivoted tables with ease
- Perform advanced operations with databases such as loading data warehouse dimensions
- Create advanced processes by nesting jobs, iterating on jobs and transformations, and creating subtransformations
Excerpt
Table of Contents (full version)
- Chapter 1 - Getting started with Pentaho Data Integration (Read an excerpt)
- Chapter 2 - Getting Started with Transformations
- Chapter 3 - Basic Data Manipulation
- Chapter 4 - Controlling the Flow of Data
- Chapter 5 - Transforming Your Data with JavaScript Code and the JavaScript Step
- Chapter 6 - Transforming the Rowset
- Chapter 7 - Validating Data and Handling Errors
- Chapter 8 - Working with Databases
- Chapter 9 - Performing Advanced Operations with Databases
- Chapter 10 - Creating Basic Task Flow
- Chapter 11 - Creating Advanced Transformations and Jobs
- Chapter 12 - Developing and implementing a simple datamart (sample chapter)
- Chapter 13 - Taking it Further
...