GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Informatica

 Print  |  
Question:  DTM Buffer Size Default Buffer Blocksize

Answer: 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.


December 12, 2008 16:48:35 #1
 calltomadhu   Member Since: September 2006    Total Comments: 34 

RE: DTM Buffer Size Default Buffer Blocksize
 
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..:-)
     

 

Back To Question