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

Naming XML Files Dynamically

Naming XML Files Dynamically

You can add a FileName column to an XML target definition to dynamically create file names for XML files. When the Integration Service passes data to the FileName column, the Integration Service overrides the output file name in the target properties. For example, if you pass the string “Harry” to the FileName column, the Integration Service names the XML file Harry.
If you are creating a new XML file on each commit, you need to dynamically name each XML file you create. If you do not dynamically name each XML file, the Integration Service overwrites the XML file from the previous commit.
The Integration Service generates a new XML file for each distinct primary key value in the root group of the target. You add a FileName column to set different names for each file. Each name overrides the output file name in the session properties.

0 COMMENTS

We’d like to hear from you!