In the Looking up data section in Chapter 6, Controlling the Flow of Data, there were missing countries in the countries.xml file. In fact, the countries were there, but with different names. For example, Russia in our file is Russian Federation in the XML file. What we should do to enhance the solution is standardize the information, sticking to a unique naming for the countries.
Modify the Transformation that looks for the language in the following way:
- Open the Transformation created in Chapter 6, Controlling the Flow of Data, and save it with a new name.
- Delete the hop that links your main stream with the Lookup Stream step.
- After reading your data, add a Value Mapper step and use it to get the standard name ...
