Powercenter - Workflow Link

Card Puncher Data Processing

About

After you create links between tasks, you can specify conditions for each link to determine the order of execution in the PowerCenter - Workflows. If you do not specify conditions for each link, the PowerCenter - Integration Service executes the next task in the workflow by default.

If the link condition evaluates to True, the Integration Service runs the next task in the workflow. The Integration Service does not run the next task in the workflow if the link condition evaluates to False. You can also use pre-defined or user-defined workflow variables in the link condition.

You can add comments using -- or // comment indicators with the Expression Editor. Use comments to describe the expression.

You can view results of link evaluation during workflow runs in the workflow log.

Double the link and enter the expression condition in the Expression Editor.

WORKFLOWSTARTTIME < TO_DATE('8/30/2010', 'MM/DD/YYYY')
// Only run the session if the workflow starts before the date specified above.

Powercenter Worklow Condition Link Expression

$wklt_FACT_LOAD.status = Succeeded
// Only run the next session if the worklet wklt_FACT_LOAD has a status to Succeded

Powercenter Workflow Link Condition





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

A workflow is a set of instructions that tells the integration service how to execute tasks, such as : session, email notifications, decisions, timers, pre-session SQL commands, post-session...



Share this page:
Follow us:
Task Runner