What is the reusable transformation?

0 Answers  

---

How to eliminate duplicates from flat file..what is the procedure

4 Answers  

---

in which situations do u go for snowflake schema ?

2 Answers   TCS,

---

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

---

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,

---

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  

---

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

---

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

---

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  

---

Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,

---

how we do performence tuning in informatica

3 Answers  

---