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

Importing an XML Target Definition from an XML File

Importing an XML Target Definition from an XML File

You can import XML definitions from an XML schema, DTD file, or XML file. You can import local files or files that you reference with a URL. To ensure that the Designer can provide an accurate definition of the data, import a target definition from an XML schema.
You can choose from the following options to create XML views:
  • Create entity relationships
    . Use this option to create views for multiple-occurring or referenced elements and complex types. You create relationships between views instead of creating one large hierarchy.
  • Create hierarchical relationships.
    Use this option to create a root and expand the XML components under the root. You can choose to create normalized or denormalized views. If you choose normalized, every element or attribute appears once. One-to-many relationships become separate XML views with keys to relate the views. If you create denormalized XML views, all elements and attributes display in one hierarchical group.
  • Create custom XML views.
    Use this option to select multiple global elements as roots for XML views and select options for reducing metadata explosion.
  • Skip creating XML views
    . Use this option to import the definition without creating any views. If you choose this option, use the XML Editor to create XML views in the workspace at a later time.
  • Synchronize XML definitions.
    Use this option to update one or more XML definitions when their underlying schemas change.
    Import DTD or XML schema files instead of XML files. If you import an XML file with an associated DTD, the XML Wizard uses the DTD.
To import XML target definitions:
  1. In the Target Designer, click Targets > Import XML Definition.
    The Import XML Definitions window opens. The local folder schema files appear by default.
  2. Click Local File or URL to browse for XML files.
  3. To browse for DTD or XML files, select the appropriate file extension from the Files of Type list.

0 COMMENTS

We’d like to hear from you!