how DTM buffer size and buffer block size are related

Question Posted / guest

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

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers IBM,

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers Polaris, Zensar,

Reusable transformation and shortcut differences

0 Answers

i have two source data there is no pk,fk how to join the two sources

5 Answers TetraSoft,

How to do unit testing in informatica?

0 Answers

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers Wipro,

How do you remove duplicate records in informatica?

1 Answers

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers CTS,

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers CTC,

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers TCS,

Whats the difference between $, $$, $$$

9 Answers

For more Informatica Interview Questions Click Here