XML Guide

10.5
- 10.5.7
- 10.5.6
- 10.4.0

Back Next

Understanding Hierarchical Relationships

An XML definition with hierarchical view relationships has each element in the hierarchy appear under its parent element in a view. Multiple-occurring elements can become views. Complex types do not become views, and elements unique to derived complex types do not occur in any view.

You can generate the following types of hierarchical view:

Normalized views.
An XML definition with normalized views reduces redundancy by separating multiple-occurring data into separate views. The views are related by primary and foreign keys.

Denormalized views.
An XML definition with a denormalized view has all the elements of the hierarchy that are not unique to derived complex types in the view. A source or target definition can contain one denormalized view.

Using XML with PowerCenter

Normalized Views

Denormalized Views

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal