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

Creating XML Definitions from Repository Definitions

Creating XML Definitions from Repository Definitions

You can import an XML source or target definition from relational or flat file definitions in the repository. When you import an XML definition from a repository definition, the XML Wizard creates an XML hierarchy from the relationships between the selected objects. The XML Wizard creates a root element for the hierarchy. You can choose a root from the groups you create. Or, you can create a separate root and relate the groups to it.
When you create an XML target definition, the XML Wizard generates keys to relate each group to the root.
To create an XML definition from repository sources or targets:
  1. In the Source Analyzer, click Sources > Import XML Definition.
    -or-
    In the Warehouse Designer, click Targets > Import XML Definition.
  2. In the XML Import dialog box, click Non-XML Sources or Non-XML Targets.
  3. Select a definition from the list of sources or targets. Click the Arrow button to add the definition to the selected source list.
    You can select more than one input and more than one input type. If the definitions are related through primary and foreign keys, the XML Wizard uses the keys to relate groups when it generates the hierarchy.
  4. To create a separate group for the root element, enter the Optional XML Rootname.
    The root name defaults to XRoot. The root group encloses all of the other groups. Remove the root name if you want to use one of the other groups as the root. The XML Wizard creates a group for each input source or target definition you select and generates a primary key in each group. The XML Wizard creates a foreign key in each group. The foreign key points to the root group link key.
  5. Click Open.
    The XML Wizard appears.
  6. Use the XML Wizard to generate the source or target groups.

0 COMMENTS

We’d like to hear from you!