0 votos Vota!!


 You can import XML definitions from DTD, XML, or XML schema files. You can import
local files or reference files using a URL.

You can choose from the following options to create XML views: Create entity
relationships.
 

  • This option enables you to create entities for some components so they do not
    expand each time the data references them. You create relationships between
    entities instead of creating one large hierarchy.
  • Create hierarchical relationships. This option creates a root and XML components expand under this root. You can choose to create normalized or denormalized views. If you choose normalized, 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.

 

  • Create entity relationships. This option enables you to create entities for some components so they do not expand each time the data references them. You create relationships between entities instead of creating one large hierarchy.
  • Create hierarchical relationships. This option creates a root and XML components expand under this root. You can choose to create normalized or denormalized views. If you choose normalized, 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..
  • Create custom XML views. This option enables you to select multiple global elements as roots for XML views and select options for reducing metadata explosion.
  • Skip creating XML views. This option creates no views. You can use the XML Editor to create XML views in the workspace at a later time.
  • Synchronize XML definitions. You can use this option to avoid reimporting the XML definition when the associated XML schema file or DTD file changes.

Note: Informatica recommends that you import DTD or XML schema files instead of XML files. PowerCenter has a size limit of 100K for XML files. If you import an XML file with an associated DTD, the XML Wizard uses the DTD.

To import XML target definitions:

  • In the Warehouse Designer, select Targets-Import XML Definition. The Import XML Definitions window opens. The default displays schema files in a local folder.
  • Click Local File or URL to browse for XML files.
  • To browse for DTD or XML files, select the appropriate file extension from the Files of Type list.