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

how can we run workflow with pmcmd?

3 Answers   Wipro,

---

Informatica settings are available in which file?

0 Answers   Informatica,

---

What is union transformation in informatica?

0 Answers  

---

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

---

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

---

---

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

---

How to differentiate between the active and passive transformations?

0 Answers  

---

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

---

Define the various join types of joiner transformation?

0 Answers  

---

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

---

What is the need of an ETL tool?

0 Answers   Informatica,

---

What are the tasks that source qualifier perform?

0 Answers   Informatica,

---