Earlier in this book, we worked solely with a flat structure—rows extracted from database tables and inserted back in a database table, or exported to a flat text file. In this recipe, we will take a look at how to prepare nested data structures inside a dataflow and then export it into an XML file as XML is a simple and very convenient way to store nested data and is most commonly used as a source and target objects in real-time jobs.
We will not need to have an XML file prepared for this recipe as we are going to generate them automatically with help of Data Services from datasets stored in our relational databases: OLTP and DWH.
We will construct the nested data structure of job title list, where each record (job title) will have a reference to a list of employees who have the same job title in the OLTP system.
Following is the visual presentation of this nested data structure:
In the flat data structure, these would be two different tables and...