Table of Contents

Search

  1. Preface
  2. XML Concepts
  3. Using XML with PowerCenter
  4. Working with XML Sources
  5. Using the XML Editor
  6. Working with XML Targets
  7. XML Source Qualifier Transformation
  8. Midstream XML Transformations
  9. Appendix A: XML Datatype Reference
  10. Appendix B: XPath Query Functions Reference

XML Guide

XML Guide

Example

Example

The Expression transformation generates a file name from the Country XML element and passes the value to the FileName column. The mapping passes a country to the target root, which is called Client. Whenever the Client value changes, the Integration Service creates a new XML file. The Integration Service creates a list file that contains each XML target file name. The Integration Service lists the absolute path to each file in the list.
The following figure shows a mapping containing an XML target with a FileName column:
The mapping contains a source, source qualifier, Expression transformation, and an XML target definition.
The Integration Service passes the following rows to the target:
Country,Region,Revenue USA,region1,1000 France,region1,10 Canada,region1,100 USA,region2,200 USA,region3,300 USA,region4,400 France,region2,20 France,region3,30 France,region4,40
The session produces the following files by country name:
Canada.xml France.xml USA.xml
The list file name is the output file name from the session properties:
revenue_file.xml.lst

0 COMMENTS

We’d like to hear from you!