In most integration scenarios, we are unlikely to find that all data fields can be passed from one system to another without any modification. Because different systems model the same objects in different ways, there's often the need, to not only change the file format, but also to change the data model and content in some way.
For our next job design, we'll do another CSV to XML transformation; but this time, the data models of the input and the output (and hence the schemas) will be different. We'll use the Studio's mapping component and Expression editor to help us deal with these differences.
To start off, let's look at our two data models to examine the differences. Our CSV file is a customer datafile and has the following fields:
Customer ID
First Name
Last Name
Address1
Address2
Town City
County
Postcode
Telephone
We know that all of these fields have a string data type and that all fields are mandatory, except for Address2.
The XML file we want to produce has a similar,...