You can create a tree source definition in the Source Analyzer. However, when you create a tree source definition, the PowerCenter Integration Service always uses vertical flattening to denormalize the tree.

To use a loose-level PeopleSoft tree as a source in a mapping, you must create the source definition. However, you can create tree source definitions for either loose-level or strict-level trees. You cannot import loose-level trees.

When you create a tree source definition, the Designer uses a predefined source in the repository that specifies the column definitions. You cannot manually edit the tree source definition.

The following table lists the columns in the created tree source definition and their descriptions:

You only need to create one tree source definition in the Source Analyzer. You can use the source definition multiple times in a mapping. However, you need to associate a particular PeopleSoft tree with each instance in a mapping. To associate a PeopleSoft tree with each instance in a mapping, import the attributes of the tree into each

instance

of the tree source definition.

Use the created tree source definition in a mapping for all PeopleSoft tree types. When denormalizing a PeopleSoft tree from a created tree source definition, the PowerCenter Integration Service makes no distinction between winter, detail, and summary trees.