Diffrence between static and dynamic cache

2 Answers   HCL,

---

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

---

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

---

what is materialized view?

2 Answers  

---

What are the various types of transformation?

0 Answers  

---

What does update strategy mean, and what are the different option of it?

0 Answers  

---

how can import the data from the flat files?

2 Answers  

---

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

---

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, 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 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

When the informatica server marks that a batch is failed?

1 Answers  

---