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
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
panel. Edit the length on the
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
XML Definition Creation Options
page of the XML Wizard, select
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.