One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  

---

lookup transformation with screenshots

0 Answers   TCS,

---

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---

what is correlated query?

2 Answers   IBM,

---

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

---

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

---

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

---

Why update strategy and union transformations are active? Explain with examples.

0 Answers  

---

How will u pas the data with out debugger?

4 Answers  

---