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

define galaxy repository in informatica

0 Answers  

---

Describe data concatenation?

0 Answers  

---

what are types of dimentions?

3 Answers  

---

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,

---

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

---

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  

---

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

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

1 Answers  

---

what is dynamic cashe

3 Answers   Informatica,

---

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

What is power play plug in?

2 Answers  

---