PowerCenter - Workflow task

Card Puncher Data Processing

Task Type

Task Type Description
58 Command
59 Decision
60 Event Wait
61 Event Raise
62 Start
65 Email
66 Timer
67 Assignment (Variable ?)
68 Session
70 Worklet
71 Workflow
91 Control

To have the type of command (task type 58), check the task_name of the table OPB_TASK

SELECT DISTINCT
  TASK_TYPE,
  COMP_TYPE.OBJECT_TYPE_NAME
FROM
  OPB_TASK TASK,
  OPB_OBJECT_TYPE COMP_TYPE
WHERE
  TASK.TASK_TYPE = COMP_TYPE.OBJECT_TYPE_ID
ORDER BY
  TASK_TYPE ASC;

Documentation / Reference

  • PC_861_WorkflowBasicsGuide.pdf - CHAPTER 5 - Tasks





Discover More
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 Workflow Sample
PowerCenter - Sessions

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...
Card Puncher Data Processing
Powercenter - Design API Sdk

You can use the Design API to read and create PowerCenter design objects. Sources and targets Transformations Mappings and mapplets Sessions, tasks, and workflows Runtime parameter files Use...



Share this page:
Follow us:
Task Runner