O'Reilly logo

Pentaho Data Integration Beginner's Guide by María Carina Roldán

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

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.

  1. Launch Squirrel and connect to the js database.
  2. Type the following sentence to change the names of the countries to upper case:
    UPDATE countries SET country_name = UCASE(country_name)
  3. Execute it. You may do this by clicking on the Run button or by pressing Ctrl + Enter.
  4. If the transformation created in the last tutorial is not open, open it again.
  5. Run the ...

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