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

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

---

Explain about cumulative Sum or moving sum?

0 Answers   Informatica,

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

How to update records in Target, without using Update Strategy?

3 Answers  

---

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,

---

if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers   BirlaSoft, IBM,

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

what is sql override?what is the use of it?

4 Answers   Sonata,

---

What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,

---

How do you use reject loader.

0 Answers  

---