Understand Informatica PowerCenter Workflow Monitor

Understand Informatica PowerCenter Workflow Monitor

You can monitor workflows and tasks in the Workflow Monitor. With the Workflow Monitor, you can view details about a workflow or task in Gantt Chart view or Task view. The Workflow Monitor displays workflows that have run at least once. You can run, stop, abort, and resume workflows from the Workflow Monitor. The Workflow Monitor continuously receives information from the Integration Service and Repository Service. It also fetches information from the repository to display historic information.

Continue Reading

Informatica PowerCenter 9 Installation and Configuration Complete Guide

Informatica PowerCenter 9 Installation and Configuration Complete Guide

This article provides complete step by step instruction for installation and configuration of Informatica PowerCenter 9.x. This includes  the installation of server components, configuration of different Informatica services and client installation and configuration.

Continue Reading

An ETL Framework for Operational Metadata Logging

An ETL Framework for Operational Metadata Logging

Quite often there is requirement to track runtime information about your ETL jobs such as record count, error count, job run time etc... In general it is a non-functional requirement, required by the IT team to have such information for reconciliation purposes, calculate performance statistics etc... It is important to have a framework, which can capture all the operational meta data you need with out adding too much time to your development cycle.

Continue Reading

Understand Informatica PowerCenter Workflow Manager

Understand Informatica PowerCenter Workflow Manager

In the Workflow Manager, you define a set of instructions called a workflow to execute mappings you build in the Designer. Generally, a workflow contains a session and any other task you may want to perform when you run a workflow. Tasks can include a session, email notification, or scheduling information. You connect each task with links in the workflow. You can also create a worklet in the Workflow Manager. A worklet is an object that groups a set of tasks. A worklet is similar to a workflow, but without scheduling information. You can run a batch of worklets inside a workflow.

Continue Reading

Event Wait Task for Dynamically Changing File Names

Event Wait Task for Dynamically Changing File Names

Whenever we schedule an Informatica Workflow, most of the times even before the actual session can run, we need to check some prerequisites like, successful completion of source system data loads, arrival of source data files etc.  Informatica PowerCenter Workflow Manager provides task such as ‘Timer’, ‘Event Wait’, Event Raise’ for such validations and checks.  In this article lets see how we can configure ‘Event Wait’ task to check the existence for a file with dynamically changing name.

Continue Reading