Answer Posted / 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.

What is the session task and command task?

1060

---

what are 3 tech challenges/ common issues you face?

2346

---

What is workflow? What are the components of the workflow manager?

1143

---

How do you change a non-reusable transformation to reusable transformation?

999

---

Tell me about Propagate functions in informatica

922

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2146

---

Explain the different lookup methods used in informatica?

1042

---

Define enterprise data warehousing?

1205

---

what is index?how it can work in informatica

2040

---

Define pmcmd command?

1047

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2003

---

What is main use of mapplet?

1133

---

How can we update a record in the target table without using update strategy?

1150

---

What are batches?

1100

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1953

---