Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Approach

Excerpt

As part of Packt's Beginner's Guide, this book focuses on teaching by example. The book walks you through every aspect of PDI, giving step-by-step instructions in a friendly style, allowing you to learn in front of your computer, playing with the tool.
The book provides short, practical examples and also builds from scratch a small datamart intended to reinforce the learned concepts and to teach you the basics of data warehousing. 


What you will learn from this book

  • 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
  • Chapter 1 - Getting started with Pentaho Data Integration
  • 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
  • Chapter 13 - Taking it Further

...