O'Reilly logo

Pentaho Data Integration 4 Cookbook by María Carina Roldán, Adrián Sergio Pulvirenti

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Looking for Data

In this chapter, we will cover:

  • Looking for values in a database table
  • Looking for values in a database (with complex conditions or multiples tables involved)
  • Looking for values in a database with extreme flexibility
  • Looking for values in a variety of sources
  • Looking for values by proximity
  • Looking for values consuming a web service
  • Looking for values over an intranet or Internet

Introduction

With transformations, you manipulate data in many ways: doing mathematical or logical operations, applying string functions, grouping by one or more columns, sorting, and much more. Besides transforming the data you already have, you may need to search and bring data from other sources. Let's look at some examples:

  • You have some product ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required