O'Reilly logo

SAP Data Services 4.x Cookbook by Ivan Shomnikov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required