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 |
Enlist the tasks for which source qualifier transformation is used.
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
diffrence between command task and control task
How to call shell scripts from informatica?
How can we improve session performance in aggregator transformation?
How can you complete unrcoverable sessions?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
What are the types of presistent cache in look up tr.
what is difference between mapping and mapplet ?
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?