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

Understand Informatica PowerCenter Mapping Designer

Understand Informatica PowerCenter Mapping Designer

A mapping is a set of source and target definitions linked by transformation objects that define the rules for data transformation. Mappings represent the data flow between sources and targets. When the Integration Service runs a session, it uses the instructions configured in the mapping to read, transform, and write data.

Continue Reading