PowerCenter - Workflows

Card Puncher Data Processing

About

A workflow is a set of instructions that tells the integration service how to execute tasks, such as :

  • email notifications,
  • decisions,
  • timers,
  • pre-session SQL commands,
  • post-session SQL commands,
  • and shell commands.

The tasks are connected by workflow link.

You create a workflow for each session you want the integration service to run.

You can group session (in parallel or sequentially) in a workflow to :

  • improve performance,
  • or to ensure that targets load in a set order.

The integration service uses the instructions configured in the workflow to run sessions and other tasks.

Powercenter Workflow Sample

You create and maintain tasks and workflows in the Workflow Manager.

Components

PowerCenter Workflows is composed of two components :

In the Workflow Manager, you define a set of instructions to execute tasks, such as sessions, emails, and shell commands. This set of instructions is called a workflow.

When the PowerCenter - Integration Service runs workflows, you can monitor workflow progress in the Workflow Monitor. You can view details about a workflow or task in either a Gantt Chart view or a Task view. You can start, stop, and abort workflows from the Workflow Monitor. The Workflow Monitor displays workflows that have run at least once.

Parallel or sequentially

Powercenter Sessions Parallel

By default, when you link both sessions directly to the Start task in the workflow manager, the integration service runs both sessions at the same time when you run the workflow. If you want the Integration Service to run the sessions one after the other, connect the Start task to one session, and connect that session to the other session.

Manage Workflow

Creating a Workflow

In PowerCenter - Workflow Manager, to create a workflow:

  • Click Tools > Workflow Designer.
  • Click Workflows > Create to create a new workflow.

When you have a workflow already open, the Workflow Manager prompts you to close the current workflow. Click Yes to close any current workflow. The workflow properties appear.

  • Name the workflow wf_WorkflowName.
  • Click the Browse Integration Service button to select an PowerCenter - Integration Service to run the workflow. The Integration Service Browser dialog box appears.
  • Select an Integration Service and click OK.

Start a workflow

  • Right-click the Start task in the workspace and select Start Workflow from Task.
  • Or right-click the workflow in the Navigator and select Start Workflow.

The PowerCenter - Workflow Monitor opens and connects to the PowerCenter - Repository.

Scheduled

By default, the workflow is scheduled to run on demand. The Integration Service only runs the workflow when you manually start the workflow. You can configure workflows to run on a schedule. For example, you can schedule a workflow to run once a day or run on the last day of the month.

  • Menu Workflows > Edit > Scheduler

Documentation

  • Documentation: PC_861_WorkflowBasicsGuide.pdf, PC_861_AdvWorkflowGuide.pdf





Discover More
Card Puncher Data Processing
PowerCenter - Application Source Qualifier Transformation

Application Source Qualifier is a transformation that represents the rows that the Integration Service reads from an application, such as an ERP source, when it runs a workflow.
Powercenter Component
PowerCenter - Architecture/Components

Architecture for 8.x version of Informatica PowerCenter. PowerCenter provides an environment that allows you to load data into a centralized location, such as a data warehouse or operational data store...
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 Metadata Manager Architect
PowerCenter - Metadata Manager

PowerCenter Metadata Manager is a metadata management tool that you can use to browse and analyze metadata from disparate metadata repositories. Metadata Manager helps you understand and manage how information...
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)...
Card Puncher Data Processing
PowerCenter - Repository Reports

PowerCenter Repository Reports are a set of prepackaged reports and dashboards to help you analyze and manage PowerCenter metadata. Use PowerCenter Repository Reports to browse and analyze PowerCenter...
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 - User and Group

With the Administration Console, you normally perform the following tasks: Create a group with all privileges on a Repository Service. The privileges allow users in to design mappings and run workflows...
Powercenter Workflow Manager
PowerCenter - Workflow Manager

In the Workflow Manager, you define a set of instructions to execute tasks, such as , emails, and shell commands. This set of instructions is called a . The Workflow Manager has the following tools to...



Share this page:
Follow us:
Task Runner