| |
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 | |