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 ?    28 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

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  


I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  


Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  


how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,






1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,


How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,


What is a code page?

0 Answers  


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers  


What is a repository manager?

0 Answers  


hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,


Categories