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

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,


How do you take back up of repository?

1 Answers  


Could any one to tell Fact table Partitioning?

2 Answers  


following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,


what is the gap analysis?

1 Answers  


Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,


Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,


How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,


In update strategy target table or flat file which gives more performance ? why?

7 Answers  


Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,


how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,


What is the Rankindex in Ranktransformation?

7 Answers  


Categories