Table of Contents

Search

  1. Preface
  2. Product Overview
  3. Before You Begin
  4. Tutorial Lesson 1
  5. Tutorial Lesson 2
  6. Tutorial Lesson 3
  7. Tutorial Lesson 4
  8. Tutorial Lesson 5
  9. Tutorial Lesson 6
  10. Naming Conventions
  11. Glossary

Getting Started

Getting Started

Importing the XML Source

Importing the XML Source

You import the Employees.xsd file to create the XML source definition.
  1. Open the Designer, connect to the repository, and open the tutorial folder.
  2. Click
    Tools
    Source Analyzer
    .
  3. Click
    Sources
    Import XML Definition
    .
  4. Click
    Advanced Options
    .
    The
    Change XML Views Creation and Naming Options
    dialog box appears.
    The following image shows
    Change XML Views Creation and Naming Options
    dialog box:
    ""
  5. Select
    Override All Infinite Lengths with value
    and enter 50.
  6. Configure the options and click
    OK
    to save the changes.
    The following table describes the options and values:
    Option
    Value
    Analyze attributes/elements in standalone XML as global declarations
    Yes
    Create an XML view for an enclosure element
    Yes
    Pivot elements when its maxOccurs is not unbounded
    Yes
    Ignore fixed elements and attributes whose content is a fixed value specified by a schema
    Yes
    Ignore prohibited attributes in XMLViews
    Yes
    Generate names for the XML columns/Select Use the element or attribute name for an XML column
    Yes
  7. In the
    Import XML Definition
    dialog box, navigate to the following directory:
    c:\PowerCenterClientInstallationDir\client\bin
  8. Select the Employees.xsd file. Click
    Open
    .
    The
    XML Wizard
    appears.
    The following image shows the
    XML Wizard
    :
    ""
  9. Verify that the name for the XML definition is Employees and click
    Next
    .
  10. Select
    Do not generate XML views
    .
  11. Click
    Finish
    to create the XML definition.
When you skip creating XML views, the Designer imports metadata into the repository, but it does not create the XML view. In the next step, you use the XML Editor to add groups and columns to the XML view.

0 COMMENTS

We’d like to hear from you!