PowerCenter
- PowerCenter 10.4.0
- All Products
Source Type
| Field
| Valid Parameter and Variable Types
|
---|---|---|
Relational
| Source Table Name
| Workflow variables, worklet variables, session parameters, mapping parameters, and mapping variables.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
PeopleSoft
| SetID,
Effective date,
Tree name,
Set control value,
Extract date
| All.
|
TIBCO
| TIB/Adapter SDK repository URL
| Service and service process variables.
|
Web Service
| Endpoint URL
| Mapping parameters and variables
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
Target Type
| Field
| Valid Parameter and Variable Types
|
---|---|---|
Relational
| Update override
Pre- and post-session SQL commands
| All.
You can specify parameters and variables in these fields when you override them in the session properties (Mapping tab) in the Workflow Manager.
|
Relational
| Target Table Name
| Workflow variables, worklet variables, session parameters, mapping parameters, and mapping variables.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
XML
| Cache directory
| Service and service process variables.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
TIBCO
| TIB/Adapter SDK repository URL
| Service and service process variables.
|
Web Service
| Endpoint URL
| Mapping parameters and variables.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
Transformation Type
| Field
| Valid Parameter and Variable Types
|
---|---|---|
Transformations that allow you to use the Expression Editor
| Transformation expressions
| Mapping parameters and variables.
|
Aggregator, Joiner, Lookup, Rank, XML Generator
| Cache directory
| Service and service process variables.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
Aggregator, Joiner, Lookup, Rank, Sorter
| Cache sizes
| Mapping parameters.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
Custom, External Procedure, HTTP, XML Parser
| Runtime location
| Service and service process variables.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
Data Masking
| Seed
| Mapping parameters and variables.
|
External Procedure
| Initialization properties
| Service and service process variables.
|
HTTP
| Base URL
| Mapping parameters and variables.
|
Lookup
| SQL override
Cache file name prefix
| All.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
Lookup
| Connection information
| Session parameters $DBConnection Name and $AppConnectionName , connection variables $Source and $Target, mapping parameters and variables.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
Sorter
| Default work directory
| Service and service process variables.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
Source Qualifier (relational source)
| SQL query
User-defined join
Source filter condition
Pre- and post-session SQL commands
| All.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
SQL
| Script file name
| Mapping parameters and variables.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
Stored Procedure
| Call text (unconnected Stored Procedure)
| All.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
Stored Procedure
| Connection information
| Session parameter $DBConnection Name , connection variables $Source and $Target.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
Web Services Consumer
| Endpoint URL
| Mapping parameters and variables.
You can specify parameters and variables in this field when you override it in the session properties (Mapping tab) in the Workflow Manager.
|
Task Type
| Field
| Valid Parameter and Variable Types
|
---|---|---|
Assignment task
| Assignment (user defined variables and expression)
| Workflow and worklet variables
|
Command task
| Command (name and command)
| Service, service process, workflow, and worklet variables
|
Command task
| Pre- and post-session shell commands
| All
|
Decision task
| Decision name (condition to be evaluated)
| Workflow and worklet variables
|
Email task
| Email user name, subject, and text
| Service, service process, workflow, and worklet variables
|
Event-Wait task
| File watch name (predefined events)
| Service, service process, workflow, and worklet variables
|
Link
| Link condition
| Service, service process, workflow, and worklet variables
|
Session
| ||
Timer task
| Absolute time: Workflow date-time variable to calculate the wait
| Workflow and worklet variables
|
Tab
| Field
| Valid Parameter and Variable Types
|
---|---|---|
Properties tab
| Session log file name
| Built-in session parameter $PMSessionLogFile.
|
Properties tab
| Session log file directory
| Service and service process variables.
|
Properties tab
| Parameter file name
| Workflow and worklet variables.
|
Properties tab
| $Source and $Target connection values
| Session parameters $DBConnection Name and $AppConnectionName , connection variables $Source and $Target.
|
Properties tab
| Pushdown optimization session property
| Mapping parameter $$PushdownConfig.
|
Config Object tab
| Session log count
| Service variable $PMSessionLogCount.
|
Config Object tab
| Session error threshold
| Service variable $PMSessionErrorThreshold.
|
Config Object tab
| Table name prefix for relational error logs
| All.
|
Config Object tab
| Error log file name and directory
| Service variables, service process variables, workflow variables, worklet variables, session parameters.
|
Config Object tab
| Number of partitions for dynamic partitioning
| Built-in session parameter $DynamicPartitionCount.
|
Mapping tab
| Transformation properties that override properties you configure in a mapping
| Varies according to property. For more information, see
Where to Use Parameters and Variables.
|
Mapping tab
| Relational connection values
| Session parameter $DBConnection Name , connection variables $Source and $Target.
|
Mapping tab
| Queue connection values
| Session parameter $QueueConnection Name.
You can override connection attributes for this connection type in the parameter file.
|
Mapping tab
| FTP connection values
| Session parameter $FTPConnection Name.
You can override connection attributes for this connection type in the parameter file.
|
Mapping tab
| Application connection values
| Session parameter $AppConnection Name.
You can override connection attributes for this connection type in the parameter file.
|
Mapping tab
| External loader connection values
| Session parameter $LoaderConnection Name.
You can override connection attributes for this connection type in the parameter file.
|
Mapping tab
| FTP remote file name
| All.
|
Mapping tab
| Lookup source file name and directory
| Service variables, service process variables, workflow variables, worklet variables, session parameters.
|
Mapping tab
| Pre- and post-session SQL commands (source and target)
| All.
|
Mapping tab
| Code page for file sources and targets
| Workflow variables, worklet variables, session parameter $Param Name.
|
Mapping tab
| Source input file name and directory
| Service variables, service process variables, workflow variables, worklet variables, session parameters.
|
Mapping tab
| Source input file command
| Service variables, service process variables, workflow variables, worklet variables, session parameters.
|
Mapping tab
| Table owner name for relational sources
| All.
|
Mapping tab
| Target merge file name and directory
| Service variables, service process variables, workflow variables, worklet variables, session parameters.
|
Mapping tab
| Target merge command
| Service variables, service process variables, workflow variables, worklet variables, session parameters.
|
Mapping tab
| Target header and footer commands
| Service variables, service process variables, workflow variables, worklet variables, session parameters.
|
Mapping tab
| Target output file name and directory
| Service variables, service process variables, workflow variables, worklet variables, session parameters.
|
Mapping tab
| Target reject file name and directory
| Service variables, service process variables, workflow variables, worklet variables, session parameters.
|
Mapping tab
| Target table name prefix
| All.
|
Mapping tab
| Teradata FastExport temporary file
| Service and service process variables.
|
Mapping tab
| Control file content override for Teradata external loaders
| All.
|
Mapping tab
| Recovery cache directory for WebSphere MQ, JMS, SAP ALE IDoc, TIBCO, webMethods, Web Service Provider sources
| Service and service process variables.
|
Mapping tab
| Durable Subscription Name
| Session parameter $Param Name.
|
Mapping tab
| MQ Source Qualifier filter condition
| All.
|
Mapping tab
| SAP stage file name and directory
| Service variables, service process variables, workflow variables, worklet variables, session parameters.
|
Mapping tab
| SAP source file directory
| Service variables, service process variables, workflow variables, worklet variables, session parameters.
|
Components tab
| Post-session email (user name, subject, and text)
| All.
|
Components tab
| Post-session email attachment file name
| All.
|
Tab
| Field
| Valid Parameter and Variable Types
|
---|---|---|
Properties tab
| Workflow log file name and directory
| Service, service process, workflow, and worklet variables.
|
Properties tab
| Workflow log count
| Service variable $PMWorkflowLogCount.
|
General tab
| Suspension email (user name, subject, and text)
| Service, service process, workflow, and worklet variables.
|
Connection Type
| Field
| Valid Parameter and Variable Types
|
---|---|---|
Relational
| Database user name, password
| Session parameter $Param Name.
Encrypt the password in the parameter file using the pmpasswd command line program with the CRYPT_DATA encryption type.
|
Relational: Source, Target, Lookup, Stored Procedure
| Connection and transaction environment SQL
| All.
|
FTP
| User name, password for host machine
| Session parameter $Param Name.
Encrypt the password in the parameter file using the pmpasswd command line program with the CRYPT_DATA encryption type.
|
FTP
| Default remote directory
| All.
|
Application
| Application user name, password
| Session parameter $Param Name.
Encrypt the password in the parameter file using the pmpasswd command line program with the CRYPT_DATA encryption type.
|
Application: Web Services Consumer
| Endpoint URL
| Session parameter $Param Name , mapping parameters and variables.
|
Application: HTTP
| Base URL
| Session parameter $Param Name.
|
Application: JMS
| JMS Destination
| Session parameter $Param Name.
|
Loader
| Database user name, password
| Session parameter $Param Name.
Encrypt the password in the parameter file using the pmpasswd command line program with the CRYPT_DATA encryption type.
|