what is Partitioning ? where we can use Partition?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differences between connected and unconnected lookup?

610


How you know when to use a static cache and dynamic cache in lookup transformation?

1345


How to load a Dimension ? and how to load a fact table?

958


What are the static cache and dynamic cache in informatica?

722


Explain the different kinds of facts.

566






hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9172


Mention some types of transformation?

607


What do mean by local and global repository?

709


What are the prerequisite tasks to achieve the session partition?

716


Define mapping and session?

587


Explain in detail about scd type 1 through mapping.

593


Explain the etl program with few examples.

550


What are the data movement modes in informatica?

707


Explain what transformation and how many are there in informatica?

494


State the differences between sql override and lookup override?

629