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

Denormalized Views

Denormalized Views

When the Designer generates a denormalized view, it creates one view and puts all elements of the hierarchy into the view. All the elements in a denormalized view belong to the same parent chain. Denormalized views, like denormalized tables, generate duplicate data.
The Designer can generate denormalized views for XML definitions that contain more than one multiple-occurring element if the multiple-occurring elements have a one-to-many relationship and are all part of the same parent chain.
The following figure shows a DTD file that contains multiple-occurring elements, in this case Product and Sales:
Product and Sales are multiple-occurring elements. Because the multiple-occurring elements have a one-to-many relationship, the Designer can create a single denormalized view that includes all elements.
The following figure shows the denormalized view for ProdAndSales.dtd in a source definition:
The ProdAndSales denormalized view source definition has three columns: Name, XPath, and Datatype.
The Designer creates a single view for all the elements in the ProdAndSales hierarchy. Because a DTD file does not define datatypes, the Designer assigns a datatype of string to all columns. The denormalized view does not need a primary or foreign key.
The following figure shows a data preview for the denormalized view:
The denormalized data preview has the following ProdAndSales element columns: SID, SNAME, PID, PNAME, PPRICE, REGION, and YTDSALES. Each column lists the corresponding data for the elements.

0 COMMENTS

We’d like to hear from you!