02-09-2012 03:55 PM
I need to generate XML files from data combined through database tables, I can use Extract transformation to get it. I need to format the XML output according to the XML file format recieved on the other end. Need to know:
1. How to generate XML file.
2. How to use SXL or any other method to format the out put to the required XML format.
I'll appreciate if some details are thrown here.