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
- 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 ...