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 are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,

---

Explain the aggregator transformation?

0 Answers  

---

Clarify the utilization of aggregator cache record?

0 Answers  

---

What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,

---

Is informatica power center designer has 64 bit support?

1 Answers  

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

When do you use sql override in a lookup transformation?

0 Answers  

---

What is the maplet?

0 Answers   Informatica,

---

Explain the use of aggregator cache file?

0 Answers  

---

What is the sequence generator transformation in informatica?

0 Answers  

---

why we are using surogate key in real time give me explanation

2 Answers   TCS,

---