Answer Posted / praveen

fact less fact table is nothing but.......
Fact table consists only s.k's nothing other than sk's...

Example::
Students Attendtance... It consists only student
information nothing other than present or absent..i.e
Boolean values(Yes or No)

What is the commit type if you have a transaction control transformation in the mapping?

973

---

What all are steps in up gradation of Informatica server?

992

---

Can we create two repositories on same database instance in oracle?

1018

---

To import the flat file definition into the designer where should the flat file be placed?

1007

---

Briefly define a session task?

1057

---

What is expression transformation?

1037

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1042

---

What is informatica metadata and where is it stored?

935

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6046

---

Explain sessions?

986

---

Define filter transformation?

1033

---

What is aggregate cache in aggregator transformation?

1067

---

What does role playing dimension mean?

998

---

Explain sql transformation in script mode examples in informatica

1048

---

Is it possible to use a client with different version than that of its Informatica server?

1077

---