Answer / srinivasulu raju

Factless fact table is used to track the Events.

Eg: Attendance System.

Answer / 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 the gap analysis?

1 Answers  

---

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  

---

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

---

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

---

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

---

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---

any body can say about all versions of informatica ?how many versions ?

2 Answers  

---

What is the procedure to load the fact table.Give in detail?

1 Answers  

---

Briefly explain the aggregator transformation?

0 Answers  

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

0 Answers  

---

what type of transformation is not supported by mapplets?

4 Answers   CTS,

---

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  

---