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 happens when a session fails and you click on recover?

651


What is mapping debugger?

568


Explain about cumulative Sum or moving sum?

617


What is the format of informatica objects in a repository?

593


Target increases every day even though no new record was inserted

1103






what is the hint? how to use it to reduce the query processing in program?

6280


In which transformation you cannot drag ports into it?

774


Explain the features of connected and unconnected lookup.

537


What are the static cache and dynamic cache in informatica?

709


How does a sorter cache works?

563


What is Session and Batches?

658


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1025


How to Create a folder using pmrep command?

618


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3319


Explain the types of transformations?

592