Answer / upender

Bulk mode option used to load huge data.
normal mode option used to load small amount of data like
less than 1000 to 10000 records. It will fail, if you use
bulk mode option, loaded just 1 or 2 records.

Define maping and sessions?

3 Answers  

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

0 Answers   TCS,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

what is diffrence b/w joner and union transfermation

6 Answers  

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

---

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

2 Answers   Deloitte, TCS,

---

How to open an older version of an object in the workspace?

0 Answers  

---

How can we use batches?

0 Answers  

---

How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,

---

When you move from devel to prod how will you retain a variable

1 Answers  

---

can we use cartesian join in informatica

3 Answers   IBM,

---

When the informatica server marks that a batch is failed?

1 Answers  

---