Interested to Buy Any Domain ? << Click Here >> for more details...
how DTM buffer size and buffer block size are related
- 3 Answers
- 31163 Views
- Wipro, I also Faced
- E-Mail Answers
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 get max value record into one target and remaining records into another target?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
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?/
in a table it has 200 rows the query is select 150 from tablename.whats the output
what is the main advantage of unconnected lookup
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
What are the connected or unconnected transforamations?
what is semi-additive fact?where did u used?
What is domain and gateway node?
What is the need of an ETL tool?
Teradata 
