Why we use partitioning the session in informatica?

Answer Posted / honey

The PowerCenter® Partitioning Option increases the
performance of PowerCenter through
parallel data processing, and it has been instrumental in
establishing PowerCenter’s industry
performance leadership. This option provides a thread-based
architecture and automatic data
partitioning that optimizes parallel processing on
multiprocessor and grid-based hardware
environments

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the modules in Power Center

1238


How to update or delete the rows in a target, which do not have key fields?

653


During the running session, output files are created by informatica server. Enlist few of them.

544


What are the performance considerations when working with aggregator transformation?

678


What is a node in Informatica?

627






WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1519


What are the different types of olap? Give an example?

564


difference between repository database and repository service?

626


Why do we need informatica?

554


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

564


What is rank transformation?

581


How might one distinguish in the case of mapping is right or not without associating session?

642


Why is sorter an active transformation?

667


expain about the tune parameters?

1890


How are the sources and targets definitions imported in informatica designer?

672