Scribd
Upload
85 views2 pages

ControlM Informatica Workflow Guide

Control-M is a workload automation tool used to schedule and manage batch jobs in Informatica PowerCenter environments. It automates workflow execution through shell scripts that utilize the pmcmd utility, with key configurations for job setup and best practices for logging and error handling. The tool also provides a GUI for monitoring job statuses and supports sequential execution of workflows to ensure data integrity.

Uploaded by

premchandchegg
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
85 views2 pages

ControlM Informatica Workflow Guide

Control-M is a workload automation tool used to schedule and manage batch jobs in Informatica PowerCenter environments. It automates workflow execution through shell scripts that utilize the pmcmd utility, with key configurations for job setup and best practices for logging and error handling. The tool also provides a GUI for monitoring job statuses and supports sequential execution of workflows to ensure data integrity.

Uploaded by

premchandchegg
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Control-M for Informatica PowerCenter Workflow Scheduling

1. Introduction

Control-M is a widely used workload automation tool that allows organizations to schedule, monitor, and manage batch
jobs. In Informatica PowerCenter environments, Control-M is commonly used to automate the execution of workflows by
triggering shell scripts that internally call Informatica's pmcmd utility.

2. Common Use Case

A shell script is written to start an Informatica workflow using pmcmd. This script is then scheduled using Control-M,
which handles execution, logging, dependency management, and alerts.

3. Sample Shell Script

Below is an example shell script to start a workflow in Informatica PowerCenter:

#!/bin/bash

DOMAIN="Domain_prod"
SERVICE="Infa_IS"
USER="infa_user"
PASS="infa_pass"
FOLDER="ETL_JOBS"
WORKFLOW="wf_Load_Customer"
LOGFILE="/home/infa/logs/${WORKFLOW}_$(date +%F_%H-%M).log"

/opt/Informatica/10.2/server/bin/pmcmd startworkflow \
-sv $SERVICE -d $DOMAIN -u $USER -p $PASS \
-f $FOLDER -wait -w $WORKFLOW >> $LOGFILE 2>&1

if [ $? -eq 0 ]; then
echo "Workflow $WORKFLOW completed successfully." >> $LOGFILE
exit 0
else
echo "Workflow $WORKFLOW failed!" >> $LOGFILE
exit 1
fi

4. Control-M Job Setup

Key fields to configure in Control-M:

Command : /home/infa/scripts/run_wf_Load_Customer.sh
Application : INFORMATICA_ETL
Job Type : Command
Control-M for Informatica PowerCenter Workflow Scheduling

Run As : infa_user
Node ID : Your Unix server name
Time : Define schedule time
Condition : Set dependencies if required
On-Do Actions : Alert on failure or retry job

5. Best Practices

- Log Management: Redirect logs using >> logfile.log 2>&1


- Exit Codes: Use proper exit codes for Control-M to recognize success/failure
- Retries: Configure retry logic in Control-M
- Dependencies: Use job dependencies to chain workflows

6. Monitoring Jobs in Control-M

Control-M provides a GUI to monitor job statuses:

- Ended OK : Job executed successfully


- Ended Not OK : Job failed
- Wait Condition : Waiting for predecessor job
- Wait Resource : Waiting for resource availability

Available actions include rerun, force OK/Fail, hold/release, and view output logs.

7. Example Workflow Chain

1. Job_Load_Customer -> runs wf_Load_Customer


2. Job_Load_Sales -> runs wf_Load_Sales (after Job_Load_Customer)
3. Job_Validate_Targets -> performs data validation and sends email

This ensures sequential execution and data integrity validation.

8. Conclusion

Control-M makes workflow orchestration in Informatica PowerCenter efficient and manageable, enabling seamless
automation and monitoring for complex data pipelines.

You might also like