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. XML Datatype Reference
  10. XPath Query Functions Reference

XML Guide

XML Guide

Editing an XML Source Qualifier Transformation

Editing an XML Source Qualifier Transformation

You can edit XML Source Qualifier transformation properties, such as transformation name and description.
To edit an XML Source Qualifier transformation:
  1. In the Mapping Designer, open the XML Source Qualifier transformation.
  2. On the Transformation tab, edit the properties.
    The following table describes the transformation properties:
    Transformation Setting
    Description
    Select Transformation
    Displays the transformation you are editing. To choose a different transformation to edit, select the transformation from the list.
    Rename
    Edits the name of the transformation.
    Description
    Describes the transformation.
  3. Click the Ports tab to view the XML Source Qualifier transformation ports.
    Use the Sequence column to set start values for generated keys in XML groups. You can enter a different value for each generated key. Sequence keys are of bigint datatype. Whenever you change these values, the sequence numbers restart the next time you run a session.
  4. Click the Properties tab to configure properties that affect how the Integration Service runs the mapping during a session.
    The following table describes the XML Source Qualifier properties:
    Properties Setting
    Description
    Select Transformation
    Displays the transformation you are editing. To choose a different transformation to edit, select the transformation from the list.
    Tracing Level
    Determines the amount of information about this transformation that the Integration Service writes to the session log when it runs the workflow. You can override this tracing level when you configure a session.
    Reset
    At the end of a session, the Integration Service resets the start values to the start values for the current session.
    Restart
    At the beginning of a session, the Integration Service starts the generated key sequence for all groups at one.
  5. Click the Metadata Extensions tab to create, edit, and delete user-defined metadata extensions.
    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.
  6. Click OK.

0 COMMENTS

We’d like to hear from you!