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 to use Normalizer transformation?

2 Answers  


we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,


What are the informatica performance improvement tips

0 Answers   Informatica,


How do you take care of security using a repository manager

2 Answers  


Where do we use mapping variables in informatica?

0 Answers  


i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.

3 Answers  


What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,


What is the functionality of update strategy?

2 Answers  


What is a sequence generator transformation?

0 Answers  


what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,


How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,


What is Code Page Compatibility?

1 Answers  


Categories