My previous sample will generate one file for output
so if my SP will return many records the result will be the same and in one output
file I will get many records.
In some cases you will need to debatch/disassemble the result and for each record
to have one separate file.
There are two ways to solve the issue
1. make disassembler changing the structure of the generated XSD
2. make loop in orchestration and retrieve records with indexer using XPath
In my next post I will show the 2nd option even it is not the best solution.
Using disassembler will work many times faster if you have many records!