Looking up data in a database

Looking up data that is stored in a database is a particular case of the process that we use for looking up data in general. We have one or more fields that are the keys for looking up data in a secondary source of data. However, when that secondary source is a database, the way we look through it is different.

For the tutorial in this section, we will use the sports database that we used in the previous chapter.

To learn how to look up data in a database table, we will start with a file containing information about injured people. The file looks like the following code:

person_id;injury_type;injury_date153;elbow;2007-07-09186;fingers;2007-07-15198;shoulder;2007-07-15213;elbow;2007-07-16378;elbow;2007-07-24

Get Pentaho Data Integration Quick Start Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.