Informatica PowerCenter: Performance Tuning Guide

Informatica PowerCenter: Performance Tuning Guide

Posted by: Jyotheswar K

Guide to tune Informatica mappings, sessions, workflows to improve performance both in coding and system level.

Overview

This document talks about tips or guidelines to be followed while improving the performance at various levels, procedure to Improve performance, how to identify Bottlenecks.The tips explained in document can help you in your day-to-day Informatica PowerCenter Performance Tuning process. In this Document, you will find:
  • Possible reasons for the low Session Load Performance
  • Methods to Identify and Eliminate Bottlenecks
  • Tips on improving the throughput
  • Options to optimize performance at various levels i.e. 
    • Source
    • Target
    • Mapping
    • Session
    • System

Features

  • Applicable to any PowerCenter version provided those transformations mentioned in the document is available.