Informatica Power Center performance – Concurrent Workflow Execution

Posted by Muralidhar Reddy
Comments (4)
September 28th, 2010

What is concurrent work flow?

A concurrent workflow is a workflow that can run as multiple instances concurrently.

What is workflow instance?

A workflow instance is a representation of a workflow.
How to configure concurrent workflow?

1) Allow concurrent workflows with the same instance name:

Configure one workflow instance to run multiple times concurrently. Each instance has the same source, target, and variables parameters.

Eg: Create a workflow that reads data from a message queue that determines the source data and targets. You can run the instance multiple times concurrently and pass different connection parameters to the workflow instances from the message queue.

2) Configure unique workflow instances to run concurrently:
Define each workflow instance name and configure a workflow parameter file for the instance. You can define different sources, targets, and variables in the parameter file.

Eg: Configure workflow instances to run a workflow with different sources and targets. For example, your organization receives sales data from three divisions. You create a workflow that reads the sales data and writes it to the database. You configure three instances of the workflow. Each instance has a different workflow parameter file that defines which sales file to process. You can run all instances of the workflow concurrently.

How concurrent workflow Works?

A concurrent workflow group’s logical sessions and tasks together, like a sequential workflow, but runs all the tasks at one time.

Advantages of Concurrent workflow?

This can reduce the load times into the warehouse, taking advantage of hardware platforms’ Symmetric Multi-Processing (SMP) architecture.


Source table records count:  150,622,276

Comments (4)

varun sharma - May 5th, 2011

yes Susmit is correct. As here for each workflow u can have different parameter files which give more flexbility in passing some parameters like source connections,file paths. ~Varun

Sri - March 28th, 2011

How to run this concurrent workflow from windows batch script....!

SUSMIT - January 30th, 2011

But in case if your source connections are different for different instances then session level partition wont work.

Upendra - January 17th, 2011

The above task can also be acheived with session partioning.Please correct me, if my understanding is wrong.

Comments are closed.