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

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,


Explain joiner transformation in informatica

0 Answers   Informatica,


Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,


what are presession,postsession success and postsession failure commands ?

1 Answers  


how to load rows into fact table in data warehouse

0 Answers   Informatica,






What is IQD file?

1 Answers  


what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  


What is the sequence generator transformation in informatica?

0 Answers  


I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,


Clarify the aggregator change?

0 Answers  


How to eliminate duplicates from flat file..what is the procedure

4 Answers  


how many data models u have done in informatica project?

2 Answers   TCS,


Categories