Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange Adapters for PowerCenter 10.5.7
  • All Products

Table of Contents

Search

  1. Preface
  2. Configuring PowerExchange for PeopleSoft
  3. Understanding PowerExchange for PeopleSoft
  4. Working with PeopleSoft Sources
  5. Application Source Qualifier for PeopleSoft Sources
  6. Accessing XLATTABLE Data
  7. Creating PeopleSoft Sessions and Workflows
  8. Appendix A: Datatype Reference
  9. Appendix B: PeopleSoft Language Codes
  10. Appendix C: Glossary

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Back Next

Tree Metadata

Tree Metadata

You can import tree metadata from the following PeopleSoft trees:
  • Detail trees
  • Summary trees
  • Winter trees
You import PeopleSoft tree metadata at different times, depending on whether you import or create the tree source definition.
When you import a PeopleSoft tree source definition, you connect to the PeopleSoft system to access the PeopleSoft metadata tables. The Designer uses metadata in these tables to create the source definition in the Source Analyzer. You cannot configure this metadata manually.
When you create a tree source definition, the Designer creates a source definition based on a predefined tree structure stored in the repository. Therefore, you do not see or import PeopleSoft tree metadata for the created tree source definition in the Source Analyzer. To associate PeopleSoft tree metadata with a created tree source definition, you import Peoplesoft tree attributes into the created tree source definition in the Mapping Designer.
The following table shows the PeopleSoft metadata the Designer imports when you import a tree in the Source Analyzer or when you import PeopleSoft tree attributes into a created tree source definition in the Mapping Designer:
Source Definition Field
Contains
Applicable Tree Source Definitions
Source Name
Tree name.
Created and imported
Business Name
Business name for the tree.
Imported
Owner Name
Owner of the tree.
Created and imported
Table Type
PeopleSoft object type (PeopleSoft tree, PeopleSoft winter tree, or PeopleSoft tree for vertical flattening).
Created and imported
SetID
A value that provides a unique identifier for each hierarchy. It is used to organize and identify data, such as MFG for Manufacturing. Each PeopleSoft tree has a SetID.
Created and imported
Effective Date
Effective date for the tree.
Created and imported
Tree Name
Name of the tree.
Created and imported
Detail Table Name
Detail record name. The field appears on the Attributes tab of the source definition when opened in the Mapping Designer.
Imported
Detail Field Name
Column in the detail record used to join the detail record with the detail tree. The field appears on the Attributes tab of the source definition when opened in the Mapping Designer.
Imported
Set Control Value
Additional identifier used by some versions of PeopleSoft to identify winter trees. The field appears on the Attributes tab of the source definition when opened in the Mapping Designer.
Created and imported
To add or view metadata for a created PeopleSoft tree source definition, open the Edit Transformations dialog box for the source definition in the Mapping Designer.
The following figure shows an imported source definition:
The PeopleSoft object type and PeopleSoft Tree appear in the Table Type field. The SetID (HC), tree name (HC_DEPARTMENTS), and effective date (01/01/1900) appear in the Description field. The PeopleSoft business name, Department Rollup, appears in the Business Name field.
0 COMMENTS
We’d like to hear from you!