PowerExchange for PeopleSoft User Guide for PowerCenter

10.5.6
- 10.5.8
- 10.5.7
- 10.5.4
- 10.5
- 10.4.0

Back Next

Using Parameters and Variables with PeopleSoft Sources

Use mapping parameters and variables in the following transformation properties of an Application Source Qualifier transformation for PeopleSoft. You can also use the system variable $$$SessStartTime:

Extract Override

Join Override

Filter

Extract Date

When you use a mapping parameter or variable for the Extract Date transformation option, the Designer includes single quotes around the mapping parameter or variable when you generate the SQL statement in the Extract Override option. Verify that the SQL statement in the extract override complies with the underlying database.

You can also use mapping parameters and variables in the following transformation properties in the source definition of a created
tree source definition in the Mapping Designer:

Tree Name

SetID

Effective Date

Set Control Value

Application Source Qualifier for PeopleSoft Sources Overview

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal