how DTM buffer size and buffer block size are related

Question Posted / guest

3 Answers
31407 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how DTM buffer size and buffer block size are related..

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

how DTM buffer size and buffer block size are related..

Answer / brahmaiah

DTM BUFFER SIZE :12MB
BUFFER BLOCK SIZE :64KB

Is This Answer Correct ?

6 Yes

3 No

how DTM buffer size and buffer block size are related..

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

Post New Answer

More Informatica Interview Questions

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers Mphasis,

How you load distinct records into one target and duplicate records into another target?

3 Answers Mphasis,

How to elaborate powercenter integration service?

0 Answers

Mention few advantages of router transformation over filter transformation.

0 Answers

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers Emirates, IBM,

How i can upload the MainFrame source For Informatica ?

1 Answers

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers CTS,

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers CTS, Symphony,

how can one eliminate dupliacte data with out using distinct option?

5 Answers Patni, Wipro,

What is meant by target load plan?

0 Answers

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers HP,

Define enterprise data warehousing?

0 Answers

For more Informatica Interview Questions Click Here