| |
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. |
| January 01, 2009 00:58:38 |
#2 |
| gaurav2485 |
Member Since: January 2009 Total Comments: 12 |
RE: DTM Buffer Size Default Buffer Blocksize
|
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. |
| |
Back To Question | |
