afzal

• May 22nd, 2006

 

The Partitioning Option increases PowerCenter’s performance through parallel data processing, and this option provides a thread-based architecture and automatic data partitioning that optimizes parallel processing on multiprocessor and grid-based hardware environments.

srinivas gogineni

• May 27th, 2006

 

partitions are used to optimize the session performance

we can select in sesstion propetys for partiotions

types

default----passthrough partition

key range partion

round robin partion

hash partiotion

nimmi

• Aug 21st, 2006

 

Hi

In informatica we can tune performance in 5 different levels that is at source level,target level,mapping level,session level and at network level.

So to tune the performance at session level we go for partitioning and again we have 4 types of partitioning

those are pass through, hash,round robin,key range.

pass through is the default one.

In hash again we have 2 types that is userdefined and automatic.

round robin can not be applied at source level, it can be used at some transformation level

key range can be applied at both source or target levels.

if you want me to explain each partioning level in detail the i can .

madhu

• Sep 23rd, 2006

 

hi nimmi please explain me regarding complete partition. I need clear picture. what tranmission it will ristrict, how it will ristric , where we have to give.

thanks

madhu.