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  

---

What is session task and command task?

0 Answers  

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,

---

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

---

What is the session task and command task?

0 Answers  

---

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

---

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

---

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

---

Can you start a session inside a batch individually?

2 Answers  

---