How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---

what is materialized view?

2 Answers  

---

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

---

what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

3 Answers   CTS, Wipro,

---

Can i create a lookup table without cache.

7 Answers   iGate,

---

what is diffrence b/w joner and union transfermation

6 Answers  

---

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

What is a unit Testing?

1 Answers  

---

What is the fact table?

0 Answers  

---

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

---