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
What is the use of target designer?
What are the different transaction levels available in transaction control transformation?
If informatica has its scheduler why using third party scheduler?
Describe data concatenation?
What is meant by incremental aggregation?
Where do we use mapping variables in informatica?
What are the informatica performance improvement tips
What is the need of etl tools?
On which transformations you created partitions in your project?
Mention some types of transformation?
What is a sorter transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to use procedural logic inside infromatica?
Differentiate between reusable transformation and mapplet.
Briefly define a session task?