You're reading from Pentaho Data Integration Beginner's Guide - Second Edition Get up and running with the Pentaho Data Integration tool using this hands-on, easy-to-read guide with this book and ebook

Product type Paperback

Published in Oct 2013

Publisher Packt

ISBN-13 9781782165040

Length 502 pages

Edition 2nd Edition

Languages

Java

Tools

Pentaho

Concepts

Data Visualization

Author (1):

María Carina Roldán

View More author details

Table of Contents (21) Chapters

Preface

1. Getting Started with Pentaho Data Integration

2. Getting Started with Transformations FREE CHAPTER

3. Manipulating Real-world Data

4. Filtering, Searching, and Performing Other Useful Operations with Data

5. Controlling the Flow of Data

6. Transforming Your Data by Coding

7. Transforming the Rowset

8. Working with Databases

9. Performing Advanced Operations with Databases

10. Creating Basic Task Flows

11. Creating Advanced Transformations and Jobs

12. Developing and Implementing a Simple Datamart

A. Working with Repositories

B. Pan and Kitchen – Launching Transformations and Jobs from the Command Line

C. Quick Reference – Steps and Job Entries

D. Spoon Shortcuts

E. Introducing PDI 5 Features

F. Best Practices

Summary

G. Pop Quiz Answers

Index

Time for action – testing the transformation that loads the region dimension

In the previous tutorial, you loaded a dimension that stores geographical information. You ran it once, causing the insertion of one record for each city and a special record with values N/A for the descriptive fields. Let's make some changes in the operational database, and run the transformation again to see what happens.

Launch Squirrel and connect to the js database.
Type the following sentence to change the names of the countries to upper case:
```
UPDATE countries SET country_name = UCASE(country_name)
```
Execute it. You may do this by clicking on the Run button or by pressing Ctrl + Enter.
If the transformation created in the last tutorial is not open, open it again.
Run the transformation.
The Step metrics tab will appear as shown in the following screenshot:
Explore the js_dw database again and do preview a of the lk_regions table. This time you will see the following: