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

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

---

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

---

What is resilience time?

0 Answers  

---

Explain what is informatica metadata and where is it stored?

0 Answers  

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

what is the difference between stop and abort

2 Answers  

---

what is confirmed fact?

2 Answers  

---

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

1 Answers   Cap Gemini,

---

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

---

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

---

What are the new features of the server manager in the informatica 5.0?

1 Answers  

---

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

---