how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---

What are roles and groups and benefits of using them?

0 Answers  

---

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

---

How to use procedural logic inside infromatica?

0 Answers  

---

What is rank transformation?

0 Answers  

---

What is the difference between IN and Exists in Oracle?

4 Answers   Deloitte,

---

what is diffrence b/w joner and union transfermation

6 Answers  

---

task is running successfully but data is not loded why?

2 Answers  

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

---

Clarify the utilization of aggregator cache record?

0 Answers  

---

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

---