如何读取XML文件生成EXCEL文件通过Data Processor in Developer Client in B2B Data Transformation

ZZ:https://kb.informatica.com/howto/6/Pages/20/512058.aspx?

Solution

INFA_Solution

There is no direct option to create Relational to Excel format.

However, using Relational > XML > Excel, you could achieve this. Data Transformation (DT) provided XmlToXlsx or XmlToExcel document processor converts XML documents to Microsoft Excel format.

However, these processors expect XML representation of an Excel workbook and it must be in the UTF-8 encoding input XML, which should be compliant to an XSD (ExcelToXml_03_07_10.xsd / ExcelToXml.xsd).

You can generate this input XML using Java transformation or it can be easily done with the following steps:

If you have Target Excel file format, then using ExcelToXml_03_07_10 (reverse of XmlToXlsx ) document processor, you can generate the input XML.

Now you need to read relational data and put the data into simple XML format and then convert into input XML.

Relational > Simple Xml > Input xml (compliant to ExcelToXml_03_07_10.xsd) > Target Excel xlxs format

Create simple XSD/XML to hold your relational data into XML format.
Create an Input hierarchy Data Processor using wizard option and select target as XML.

New > Transformation > Data processor > Choose Create a data processor using a wizard option > Input format (Relational Data) > Output Format (XML ) > Select already created XML/XSD format > Finished.
Create another Data processor and using Script convert this simple XML to input XML with ExcelToXml_03_07_10.xsd standard.

You can use serializer which can generate the required XML and then call the document processor XmlToXlsx to generate target XML.

Refer attached project (Transformation DP_XML_EXCEL) to understand how to do this.