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)

What is difference macros and prompts?

2 Answers  

---

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,

---

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 any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

---

Without source how to insert record to target?

6 Answers  

---

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

---

What is workflow manager?

0 Answers  

---

What are the designer tools for creating transformations?

0 Answers   Informatica,

---

Target is zero file and how can you send the email?

2 Answers   Bank Of America,

---

How can we use mapping variables in informatica? Where do we use them?

0 Answers  

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,

---

What is a stored procedure transformation?

0 Answers  

---