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

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  


How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 Answers  


1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,


What is Cognos script editor?

0 Answers   Cognizant,


What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,






what we require for D.modelling?

1 Answers  


What are data-driven sessions?

0 Answers  


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

5 Answers   iGate,


Enlist few areas or real-time situations where informatica is required.

0 Answers  


What is informatica etl tool?

0 Answers  


What is repository manager?

0 Answers  


If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  


Categories