Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. Glossary

XSD Import Guidelines

XSD Import Guidelines

Read the following information before you import an XSD file into the PowerCenter repository from PowerCenter Designer:
  • To open the
    Change XMLViews Creation and Naming Options
    window, click
    Advanced Options
    in the
    Import XML Definition
    dialog box. Set the following options for the import:
    • Choose to override all infinite lengths with a low value. The value is the default length if the XSD file does not specify a length. You do not require a high value if the elements are of a small length. A high length value requires more memory and affects the performance. Select the option and enter an override value.
    • If the data contains elements that require a higher precision, manually set the precision of the element to the required value after you import the file. Open the file in PowerCenter Designer and select the element in the
      Schema Components
      panel. Edit the length on the
      Actions
      tab.
    • Choose to analyze elements and attributes in standalone XML as global declarations. Required in TDM to ensure correct mapping of the namespaces of the different elements and attributes. Import of the XSD in TDM fails if the namespaces of elements and attributes are not mapped correctly.
    • Use the default settings for the other options.
    • Enter a value for the
      Default length for anyType element mapped to string
      option.
  • In the
    XML Definition Creation Options
    page of the XML Wizard, select
    Hierarchy Relationships
    and the
    Normalized XML Views
    option. Use this option to create a root and expand the XML components under the root. When you choose normalized XML views, 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.