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 apply some changes in the operational database, and run the transformation again to see what happens.Launch MySQL Query Browser.
Type the following sentence to change the names of the countries to upper case:
UPDATE countries SET country_name = UCASE(country_name)
Execute it.
If the transformation created in the last tutorial is not open, open it again.
Run the transformation.
The Step Metrics looks like this:
Explore the
js_dw
database again and do a preview of thelk_regions
table. This time you will see the following:
![country flag](/images/countries/argentina.png)
![country flag](/images/countries/australia.png)
![country flag](/images/countries/austria.png)
![country flag](/images/countries/belgium.png)
![country flag](/images/countries/brazil.png)
![country flag](https://cdn.packtpub.com/flag/004da5c4-583f-4e69-a0a8-0e999f350f90_128px-Flag_of_Bulgaria.png)
![country flag](/images/countries/canada.png)
![country flag](/images/countries/chile.png)
![country flag](/images/countries/colombia.png)
![country flag](/images/countries/cyprus.png)
![country flag](/images/countries/czech.png)
![country flag](/images/countries/denmark.png)
![country flag](/images/countries/ecuador.png)
![country flag](/images/countries/egypt.png)
![country flag](/images/countries/estonia.png)
![country flag](/images/countries/finland.png)
![country flag](/images/countries/france.png)
![country flag](/images/countries/germany.png)
![country flag](/images/countries/gb.png)
![country flag](/images/countries/greece.png)
![country flag](/images/countries/hungary.png)
![country flag](/images/countries/india.png)
![country flag](/images/countries/indonesia.png)
![country flag](/images/countries/ireland.png)
![country flag](/images/countries/italy.png)
![country flag](/images/countries/japan.png)
![country flag](/images/countries/latvia.png)
![country flag](/images/countries/lithuania.png)
![country flag](/images/countries/lux.png)
![country flag](/images/countries/malaysia.png)
![country flag](/images/countries/malta.png)
![country flag](/images/countries/mexico.png)
![country flag](/images/countries/netherlands.png)
![country flag](/images/countries/newzealand.png)
![country flag](/images/countries/norway.png)
![country flag](/images/countries/philippines.png)
![country flag](/images/countries/poland.png)
![country flag](/images/countries/portugal.png)
![country flag](/images/countries/romania.png)
![country flag](/images/countries/russia.png)
![country flag](/images/countries/singapore.png)
![country flag](/images/countries/slovakia.png)
![country flag](/images/countries/slovenia.png)
![country flag](/images/countries/southafrica.png)
![country flag](/images/countries/southkorea.png)
![country flag](/images/countries/spain.png)
![country flag](/images/countries/sweden.png)
![country flag](/images/countries/switzerland.png)
![country flag](/images/countries/taiwan.png)
![country flag](/images/countries/thailand.png)
![country flag](/images/countries/turkey.png)
![country flag](/images/countries/ukraine.png)
![country flag](/images/countries/us.png)