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

Editing XML Target Definition Properties

Editing XML Target Definition Properties

After you create an XML target definition, you can edit the properties to reflect changes in the target data, add business names and comments, or change the code page.
To edit XML target definition properties:
  1. Open the XML target in the Target Designer.
  2. Right-click and select Edit.
  3. On the Table tab, edit the settings.
    The following table describes the Table settings:
    Table Settings
    Description
    Select Table
    Name of the target definition. To change the name, click the Rename button.
    Business Name
    Descriptive name for the target table. Edit the Business Name using the Rename button.
    Constraints
    Not applicable to XML targets. Any entry is ignored.
    Creation Options
    Not applicable to XML targets. Any entry is ignored.
    Description
    Description of target table. Character limit is 2,000 bytes/K, where K is the maximum number of bytes for each character in the repository code page. Enter links to business documentation.
    Code Page
    Select the code page to use in the target definition.
    Database Type
    Indicates that the target definition is an XML target.
    Keywords
    Use keywords to organize and identify targets. Keywords might include developer names, mappings, or XML schema names.
    Use keywords to perform searches in the Repository Manager.
  4. On the Columns tab, you can view XML column definitions.
    The following table describes the Columns settings:
    Columns Settings
    Description
    Select Table
    Displays the target definition you are editing. To choose a different definition to edit, select one from the list of definitions you have available in the workspace.
    Column Name
    Name of the column.
    Datatype
    PowerCenter datatype for the column.
    Precision
    Size of column. You can change precision for some datatypes, such as string.
    Scale
    Maximum number of digits after the decimal point for numeric values.
    Not Null
    Indicates if the column can have null values.
    Key Type
    Type of key the XML Wizard generates to link the views.
    XPath
    Path through the XML file hierarchy that locates an item.
  5. On the Properties tab, you can modify the transformation attributes of the target definition.
    If you use a source-based commit session or Transaction Control transformation with the XML target, you can define how you want to flush data to the target.
    The following table describes the attributes that you can edit:
    Columns Settings
    Description
    Select Table
    Displays the source definition you are editing. To choose a different source definition to edit, select the source definition from the list.
    Duplicate Group Row Handling
    Choose one of these options to handle processing duplicate rows in the target:
    • First Row
      .
      The Integration Service passes the first duplicate row to the target. Rows following with the same primary key are rejected.
    • Last Row
      .
      The Integration Service passes the last duplicate row to the target.
    • Error
      .
      The Integration Service passes the first row to the target. Rows with duplicate primary keys increment the error count. The session fails when the error count reaches the error threshold.
    DTD Reference
    DTD or XML schema file name for the target XML file. The Integration Service adds the document type declaration to the XML file when you create the XML file.
    On Commit
    The Integration Service can generate multiple XML files or append to one XML file after a commit. Use one of the following options:
    • Ignore Commit. The Integration Service creates an XML file and writes to the XML file at end of file.
    • Create New Document. Creates a new XML file at each commit.
    • Append to Document. Writes to the same XML file after each commit.
    Cache Directory
    Directory for the XML target cache files. Default is the $PMCacheDir service process variable.
    Cache Size
    Total size in bytes for the XML target cache. Default is auto.
  6. On the Metadata Extensions tab, you can create, modify, delete, and promote non-reusable metadata extensions, and update their values. You can also update the values of reusable metadata extensions.
  7. Click OK.
  8. Click Repository > Save.

0 COMMENTS

We’d like to hear from you!