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

what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,

---

What is pmcmd command?

0 Answers  

---

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

---

How the dimensions will be loaded?

0 Answers   HCL,

---

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,

---

---

What is union transformation?

0 Answers  

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,

---

Differentiate between Load Manager and DTM?

0 Answers  

---

Explain the different dimensions.

0 Answers  

---

how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,

---

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

---

How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 Answers  

---