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
Differences between connected and unconnected lookup?
How you know when to use a static cache and dynamic cache in lookup transformation?
How to load a Dimension ? and how to load a fact table?
What are the static cache and dynamic cache in informatica?
Explain the different kinds of facts.
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
Mention some types of transformation?
What do mean by local and global repository?
What are the prerequisite tasks to achieve the session partition?
Define mapping and session?
Explain in detail about scd type 1 through mapping.
Explain the etl program with few examples.
What are the data movement modes in informatica?
Explain what transformation and how many are there in informatica?
State the differences between sql override and lookup override?