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
Explain pushdown optimization $pushdownconfig parameter - informatica
What do you understand by term role-playing dimension?
What is meant by target load plan?
What is the benefit of partitioning a session?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is a connected transformation?
Define sessions in informatica etl?
What's the layout of parameter file (what does a parameter file contain?)?
What is data movement mode in Informatica and difference between them?
What are the tasks that can be performed using sq?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is lookup transformation?
draw informatica architecture 8.6 ?
What is the scenario which compels informatica server to reject files?