how DTM buffer size and buffer block size are related
Answers were Sorted based on User's Feedback
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 |
Answer / brahmaiah
DTM BUFFER SIZE :12MB
BUFFER BLOCK SIZE :64KB
Is This Answer Correct ? | 6 Yes | 3 No |
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 |
How to use Normalizer transformation?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
What are the informatica performance improvement tips
How do you take care of security using a repository manager
Where do we use mapping variables in informatica?
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
What is Collect performance data in informatica and what is the use of it.
What is the functionality of update strategy?
What is a sequence generator transformation?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
How to convert flat file into xml file? How to tune joiner?
What is Code Page Compatibility?