can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

---

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 a design?

1 Answers  

---

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

---

can u give example for factless fact table

2 Answers   TCS,

---

What is partioning?how many types of partinings are there

2 Answers   HCL,

---

what are the limitation of sorter transformation?

2 Answers   TCS,

---

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

---

what is update strategy transformation ?

7 Answers   TCS,

---

How to call shell scripts from informatica?

0 Answers  

---

how many session run unix environment what command using ?

1 Answers   HCL,

---

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

---