What is aggregate cache in aggregator transforamtion?

5 Answers  

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

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 diff b/t sorter t/r and agg have the option sorter property...

0 Answers  

---

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

Explain the informatica workflow?

0 Answers  

---

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

---

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

---

Why do you use Mapping Parameter and mapping variable?

0 Answers  

---

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

---