how DTM buffer size and buffer block size are related

Answers were Sorted based on User's Feedback



how DTM buffer size and buffer block size are related..

Answer / nandini

The number of buffer blocks in a session = DTM Buffer
Size / Buffer Block Size. Default settings create enough
buffer blocks for 83 sources and targets. If the session
contains more than 83, you might need to increase DTM
Buffer Size or decrease Default Buffer Block Size.

Is This Answer Correct ?    10 Yes 2 No

how DTM buffer size and buffer block size are related..

Answer / brahmaiah

DTM BUFFER SIZE :12MB
BUFFER BLOCK SIZE :64KB

Is This Answer Correct ?    6 Yes 3 No

how DTM buffer size and buffer block size are related..

Answer / anand kumar

(total number of sources + total number of targets)* 2] =
(session buffer blocks)

(session Buffer Blocks) = (.9) * (DTM Buffer Size) /
(Default Buffer Block Size) * (number of partitions)

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Informatica Interview Questions

what is mapping override?

2 Answers   Cap Gemini,


Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,


What is meant by a domain?

0 Answers  


How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,


What are ETL Tools?

0 Answers   Informatica,






what is casual dimension?

6 Answers   IBM,


Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  


Explain the different kinds of facts.

0 Answers  


i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  


What do you mean by channel change?

0 Answers  


Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  


Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  


Categories