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.

Getting ready

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 ...

Get SAP Data Services 4.x Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.