Why we use partitioning the session in informatica?

Answers were Sorted based on User's Feedback



Why we use partitioning the session in informatica?..

Answer / swetha

Partitioning achieves the session performance by reducing
the time period of reading the source and loading the data
into target.

Is This Answer Correct ?    14 Yes 8 No

Why we use partitioning the session in informatica?..

Answer / 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

More Informatica Interview Questions

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,


can we see default group,when we use router?if yes how?

2 Answers   L&T,


Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  


hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  


After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  


Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,


What is mapping debugger?

0 Answers  


How can you access the remote source into your session?

1 Answers  


what is the size of u r project? and what is the size of source file?

1 Answers   HP,


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,


What is joiner transformation?

0 Answers  


Categories