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.

Answer / brahmaiah

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

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)

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

---

What is event and what are the tasks related to it?

0 Answers  

---

What is batch and describe about types of batches?

2 Answers  

---

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

Difference between session variables and workflow variables?

2 Answers   Informatica,

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,

---

What is joiner cache?

2 Answers   TCS,

---

how many data models u have done in informatica project?

2 Answers   TCS,

---

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

---

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

---

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  

---

can we override a native sql query within informatica? How do we do it?

0 Answers  

---