Answer Posted / ankit kansal

Take two dimensions as dim_time and dim_product and
a fact table as fact_sales
Now provide a reference from both of the dim tables to the fact table and while loading from the source do not load any other data.
Now you can easily report out
product sold per day
product sold per month
product sold per year
e.t.c.

deepinopensource.blogspot.in

What is mapping debugger?

1021

---

EXL informatica Questions

1395

---

wf dont have integration severances how you can run?

1941

---

What are data-driven sessions?

1218

---

Explain the types of lookup transformation?

1046

---

What is powercenter on grid?

1181

---

Explain joiner transformation in informatica

1128

---

What are the features of complex mapping?

1161

---

Which are the different editions of informatica powercenter that are available?

1034

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1207

---

What is target load order?

1250

---

What is the difference between informatics 7x and 8x and what is latest version?

1086

---

What is aggregator transformation in informatica?

953

---

What is an unconnected transformation?

1088

---

Could you explain what is enterprise data warehouse?

1148

---