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

Adding a FileName Column

Adding a FileName Column

When you run a session, the Integration Service outputs a new target XML file each time a new root value occurs in the data. You can add a FileName column to an XML view to generate a unique file name for each XML file. The file name overrides the default output file name in the session properties.
When you use the FileName column, you set up an Expression transformation or other transformation in the mapping to generate the unique file names to pass to FileName column.
To create a FileName column in an XML view:
  1. Right-click the view in the XML Editor.
  2. Select Create FileName Column.
    The XML Editor creates a new string column in the view.
  3. Change the column name in Columns window.
  4. Exit the XML Editor.
    The column appears in the XML definition. The XPath is $Filename.
    When you use XML FileName ports, you need to specify the directory name for the file.

0 COMMENTS

We’d like to hear from you!