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

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers  

Explain the different dimensions.

0 Answers  

What is the target load order?

3 Answers   HCL, Informatica,

why we r using presql&postsql in source qualifier?

1 Answers   HP,

What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

What is difference between a connected look up and unconnected look up?

6 Answers  

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  


6 Answers  

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

7 Answers   TCS,