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 |
Can I create one wrkflw which will run different wrkflws on schedule time?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Is there any model difference between ODS and DWH
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
In a table, 4 person having same salary. How to get Third person record only?
What are batches?
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
Which files are created during the session rums by informatics server?
Define maping and sessions?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
Can we get 1st record through Informatica(without sequence number).