Answer / kalpana

costbased and rule based approaches r used as optimization
techniques in improving the performance of queries

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---

What is a sequence generator transformation?

0 Answers  

---

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

---

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,

---

Why we require dwh in particular projects?

1 Answers   Amdocs,

---

How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  

---

Enlist few areas or real-time situations where informatica is required.

0 Answers  

---

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

---

.prm wirh repalce .txt is possible?

2 Answers  

---

need for registering a repository server

1 Answers  

---