how DTM buffer size and buffer block size are related

Question Posted / guest

3 Answers
31166 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

What if the source is a flat-file?

0 Answers

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com

0 Answers

Explain sessions?

0 Answers

suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers TCS,

In any project how many mappings they will use(minimum)?

1 Answers

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?

1 Answers Emphasis,

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers BirlaSoft,

can anyone suggest best free Talend data integration training online

0 Answers

how to design mapping half of source table records into one target and remaining half into another target

8 Answers ABC,

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers TCS,

Could you explain what is enterprise data warehouse?

0 Answers

What is a difference between complete, stop and abort?

0 Answers

For more Informatica Interview Questions Click Here