Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  

---

How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 Answers  

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  

---

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

---

Explain the use of aggregator cache file?

0 Answers  

---

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

---

What are the advantages of informatica?

0 Answers  

---

What is polling in informatica ?

1 Answers   TCS,

---

What is a mapplet/worklet in informatica?

0 Answers  

---

What are the Differences between connected and unconnected lookup?

6 Answers   TCS,

---

How will you update the row without using update statergy?

10 Answers   CTS,

---

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,

---