Working with nested structures
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 ...