what is Partitioning ? where we can use Partition?




Answers were Sorted based on User's Feedback



what is Partitioning ? where we can use Partition?..

Answer / mahesh

The Partitioning Option increases Power Center?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.
Partitions are used to optimize the session performance. We
can select in session properties for partitions
Types- Default----pass through partition, key range
partition, round robin partition, hash partition.

Is This Answer Correct ?    27 Yes 5 No

what is Partitioning ? where we can use Partition?..

Answer / annu

Partitioning is a utility provided by informatica which
evolves nature of parallel processing on a grid or
multiprocessor database architecture. Partition means
a "thread of ETL data load in chunks". Like Unix, Multiple
data load thead will be executed parallely and sync up the
result set to one instance of Target.

For more detail of using Informatica Partitioning with
visual graphs
visit : http://informatica-tech-talk.blogspot.com/

Is This Answer Correct ?    4 Yes 0 No

Post New Answer




More Informatica Interview Questions

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  


wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  


which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,


what is Partitioning ? where we can use Partition?

2 Answers   TCS, IBM,


In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,






I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  


Is it possible to revert a global repository to local one and why?

0 Answers  


My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,


Can a joiner be used in a mapplet.

1 Answers  


Why we use stored procedure transformation?

4 Answers  


What is IQD file?

1 Answers  


what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,






Categories