PowerCenter - Sessions

Card Puncher Data Processing


Powercenter Workflow Sample

Powercenter Session

A session is a type of workflow task. A session is a set of instructions that tells the integration service how to move data from sources to targets using a mapping. You create a session for each mapping that you want the integration service to run.

The integration service uses the instructions configured in the session and mapping to move data from sources to targets.

A session is a task, similar to other tasks available in the workflow manager.

In workflow manager, you can create :

  • reusable sessions in the Task Developer. You can use it in multiple workflows.
  • non-reusable sessions in the Workflow Designer. You can use it only in that workflow.

Type of session


A reusable session can be used in multiple workflows and is not contained within any mapplet or mapping

To create it:

  1. In the workflow manager Navigator, double-click a folder to open it.
  2. Click Tools > Task Developer to open the Task Developer.
  3. Click Tasks > Create.
  4. Select Session as the task type to create.
  5. Enter s_SessionName


A non-reusable can be only used in one workflow because it's contained within the mapplet or mapping

To create it:

  1. In the workflow manager Navigator, click Tools > Worklow Designer to open the Worklow Designer.
  2. Click Tasks > Create.

The Workflow Designer provides more task types than the Task Developer. These tasks include the Email and Decision tasks.

Powercenter Task Non Reusable

  1. Select Session as the task type to create.
  2. Enter s_SessionName

Metadata API

Powercenter Sessie Config Object Metadata

Tab Database View Java Class Note
General Task
Properties REP_TASK_ATTR SessionPropsConstants
Config Object REP_SESS_CONFIG_PARM SessionPropsConstants All CFG constant such as SessionPropsConstants.CFG_STOP_ON_ERRORS
Component REP_COMPONENT presession_variable_assignment and postsession_success_variable_assignment are task
Mapping ConnectionPropsConstants

Java Example:

  • Task
ipcSession.setTaskInstanceProperty(Task.FAIL_PARENT_IF_INSTANCE_FAILS, "YES");
  • SessionPropsConstants
ipcSession.getProperties().setProperty(SessionPropsConstants.TREAT_SOURCE_ROWS_AS, "Data driven");
  • ConnectionPropsConstants
ipcTarget.getProps().setProperty(ConnectionPropsConstants.RELATIONAL_TARGET_LOADTYPE, "Normal");

Discover More
Card Puncher Data Processing
PowerCenter - Naming Conventions

The following naming conventions appear throughout the PowerCenter documentation and client tools. Use the following naming conventions when you design mappings and create sessions. The following...
Card Puncher Data Processing
PowerCenter - Client

The PowerCenter Client consists of the following applications that you use to manage the repository, design mappings, mapplets, and create sessions to load the data: . Use the Designer to create mappings...
Powercenter Integration Service
PowerCenter - Integration Service

The PowerCenter Integration Service is an application service that runs workflows and sessions for the PowerCenter Client. The Integration Service reads workflow information from the repository. The...
Powercenter Log
PowerCenter - Logging

The Service Manager provides accumulated log events from each service in the domain. You can view logs in: the Administration Console and the Workflow Monitor. PowerCenter_Home\server\infa_shared\SessLogs...
Powercenter Mapping Pass Through
PowerCenter - Mapping

Mapping depict the flow of data between source and targets. A Pass-Through mapping inserts all the source rows into the target. To create and edit mappings, you use the Mapping Designer tool in the...
Powercenter Pre Session Variable Assignment
PowerCenter - Mapping (Parameter|Variable)

When you use a mapping parameter or variable in a mapping, first you declare the mapping parameter or variable for use in each mapplet or mapping. Then, you define a value for the mapping parameter or...
Powercenter Parameter File
PowerCenter - Parameter File (prm)

A parameter file is a way to hold the initial value of Mapping parameter or variable. You can set its location into the session attributes. # or ; for comments Mapping parameter and variable...
Card Puncher Data Processing
PowerCenter - Repository Objects

You create repository objects using the and client tools. You can also view the objects in the Navigator window of the . source definitions. Definitions of database objects (table, views, synonyms)...
Powercenter Transformation Store Procedure Import
PowerCenter - Stored Procedure Transformation

Stored procedure in the context of PowerCenter. Create a Stored Procedure transformation and name it SP_TransformationName. The Import Stored Procedure dialog box appears. Select the ODBC...
Powercenter Workflow Manager Connections
PowerCenter - Targets

PowerCenter can load data into the following targets: Relational. Oracle, Sybase ASE, Sybase IQ, Informix, IBM DB2, Microsoft SQL Server, and Teradata. File. Fixed and delimited flat file and XML....

Share this page:
Follow us:
Task Runner