Answer / suraj kedia

Aggregator transformation is used to calculate values in a
group. It is the only t/r which can be used for aggregate
calculations e.g: Sum,avg,max,min,count....

So when we don't need any such aggregate calculations, than
we don't use aggregator transformation.

Answer / vikram

when thre are no group by or any other calculations required

What is status code in informatica?

1 Answers  

---

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

---

What are the different lookup cache(s)?

1 Answers  

---

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

---

What are the active and passive transforamtions?

2 Answers  

---

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1 Answers  

---

When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers  

---

what is mapping override?

2 Answers   Cap Gemini,

---

How many repositories can we create in Informatica?

3 Answers  

---

What are the challenges of Dataware housing in the future?

2 Answers   HP,

---