What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

---

what is parameter file?

1 Answers   Cap Gemini,

---

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 the procedure to load the fact table.Give in detail?

1 Answers  

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---

without update strategy how to insert &update?

1 Answers   DELL,

---

Two Default User groups created in the repository are ____ and ______

2 Answers  

---

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,

---

how to load rows into fact table in data warehouse

0 Answers   Informatica,

---

Explain how many types of dimensions are available in informatica?

0 Answers  

---