PowerExchange for PeopleSoft User Guide for PowerCenter

10.4.0
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5

Back Next

Importing Trees

You import strict-level trees from the Trees tab of the Import from PeopleSoft dialog box. Detail and summary trees appear in the Trees folder. Winter trees appear in the Winter Tree folder.

The Designer displays the following tree information in the Import from PeopleSoft dialog box to help you identify the tree you want to import:

SetID.
If a tree has a SetID, it appears before the tree name.

Tree name.
The name of the tree.

Effective date.
The tree effective date appears after the tree name.

PeopleSoft uses SetID and effective dates to identify trees. When importing a tree from PeopleSoft, use the SetID and effective date to select the tree. The SetID and effective date appear in the resulting source definition in the Source Analyzer.

PowerExchange for PeopleSoft only imports
strict-level trees. When you import a strict-level tree, the PowerCenter Integration Service uses horizontal flattening to denormalize the tree.

To use a loose-level tree as a source, you must create the source definition.

When you import strict-level trees, the Designer creates columns for the following:

Root node level.
The Designer creates single column for the root node level and names it LEVEL_
RootNodeName
.

Branch node levels.
The Designer creates a column for each branch node level in the tree and names each column LEVEL_
BranchNodeLevel
.

Detail ranges.
The Designer creates columns named RANGE_FROM and RANGE_TO to represent the detail ranges in detail and summary trees. Winter trees do not have detail ranges.

Rename Saved Search

Table of Contents

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Importing Trees

Importing Trees