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 informatica recognizes mapping?

2 Answers   CTS,

---

How to do unit testing in informatica?

0 Answers  

---

How will u pas the data with out debugger?

4 Answers  

---

What is informatica?

0 Answers  

---

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---

What is a filter transformation and why it is an active one?

0 Answers  

---

What are events in workflow manager?

1 Answers   Accenture, IBM,

---

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  

---

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

Explain grouped cross tab?

1 Answers   Accenture,

---

What is a pre-defined event and user-defined event?

0 Answers  

---