hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,

---

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  

---

What is junk dimention?

3 Answers   Patni,

---

What is the difference between view and materialised view?

4 Answers  

---

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

---

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  

---

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

---

which one is better performance wise joiner or look up

0 Answers   Informatica,

---

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

---

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

---

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---