DTM Buffer Size Default Buffer Blocksize

What is DTM buffer size, Default buffer blocksize. If any performance issue happens to session, which one we have to increase and which one we have decrease.

superhero
Profile Answers by superhero Questions by superhero
Dec 5th, 2008
6
25561

Questions by superhero answers by superhero

Informatica

Answer

Showing Answers 1 - 6 of 6 Answers

calltomadhu
Profile Answers by calltomadhu

Dec 31st, 2008

Hey,

workflow manage allocate default of 12MB size to session. you can increase this according to you requirement by specifying them in the form of bytes or you can set to AUTO it will take accordingly.

you need to increase the DTM buffer size when you are dealing with large set of character data and you configured it to run on unicode mode. increase the DTM buffer to 24 MB.

i guess i cleared your question..:-)

gaurav2485
Profile Answers by gaurav2485

Jan 8th, 2009

DTM buffer size is memory you allocate?to DTM process (12 MB)
Buffer Block size is Size of heaviest Source/Target* number of rows that can be moved at a time(should be minimum 20 (64 KB)
And Informatica bydeault assign it to be as for 83 sources and Targets(Buffer Memory)

So we should increase/decrease size accordingly
if more then 83 sources and Target then we should increase DTM and if source or target are heavy we should go with increasing buffer Block size.