Answer / deepthi

1.Use sorted data and enable option 'sorted i/p'
2.By using incremental aggregation
3.group by simple columns like numeric columns
4.use filter transformation before aggregator to avoid
unnecessary aggregation on unwanted columns.

Answer / ritu

By giving sorted inputs and do not forget to tick the
sorted input box

Answer / uzval_vee

Place the agg transformation after souce qualifier,becoz
if yur using filter,sorting before agg ,it will reduce the
agg performance .according to my view

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,

---

where to select code page option?

2 Answers   TCS,

---

How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,

---

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,

---

Explain the difference between a data warehouse and a data mart?

0 Answers  

---

---

What is aggregate awareness?

1 Answers  

---

what is diff between grep and find

3 Answers   IBM, iFlex,

---

When you move from devel to prod how will you retain a variable

1 Answers  

---

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

---

How to display First letter of Names in Caps?

7 Answers  

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

why we use datawarehouse

0 Answers   HCL,

---