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

2 Answers  

---

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

---

Define enterprise data warehousing?

0 Answers  

---

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

---

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

---

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

---

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

---

How do you take back up of repository?

0 Answers  

---

What is the use of transformation?

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,

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

WHAT IS FACT TABLES?

2 Answers  

---