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 |
in static and dynamic which one is better
Why we require dwh in particular projects?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
What is the Rankindex in Ranktransformation?
How many joins in Informatica
In joiner, how to load Master table in Target?
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
how to join the two flatfiles using the joiner t/r if there is no matching port?
What is the need of an ETL tool?
Define the various join types of joiner transformation?
What is the difference between view and materialised view?