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

Creating Custom XML Views

Creating Custom XML Views

You can create custom XML views using the XML Wizard. When you create custom views, you can choose roots and specify how to generate metadata. You can choose to include or exclude global elements based on whether the root information applies to the data you intend to process. For example, if the schema contains information about stores and customers, you might want to create an XML definition that processes just the customers.
You can specify how you want to generate metadata associated with the view. You can reduce metadata explosion for elements, complex types, and inherited complex types by generating entity relationships. If you do not reduce the metadata references, the Designer generates hierarchy relationships and expands all child elements under their parent elements.
To create a custom view using the XML Wizard:
  1. In the Source Analyzer, click Sources > Import XML Definition.
    The XML Wizard opens.
  2. Navigate to the source you want to import and click Open.
  3. Enter a name for the file and click Next.
  4. Select Create Custom XML Views and click Next.
    To manually create all the XML views in the XML Editor, select Skip Create XML Views. The XML Wizard creates the schema in the repository, but does not create the XML views.
  5. Select root elements from the list of global root elements and click Next.
  6. Choose to reduce metadata for elements, complex types, or inherited complex types and click Finish.

0 COMMENTS

We’d like to hear from you!