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)

Explain the use of aggregator cache file?

1259

---

What is complex mapping?

1127

---

Separate from a database, an information bazaar, and an information stockroom?

1091

---

Explain incremental aggregation in informatica

1136

---

How do you load unique records into one target table and duplicate records into a different target table?

1268

---

What is the Process to creating lookup transformation in informatica

1047

---

How to do unit testing in informatica?

1180

---

How to go to the older version for a mapping?

1102

---

How do you change a non-reusable transformation to reusable transformation?

1002

---

Write the unconnected lookup syntax and how to return more than one column.

1112

---

whats the logic to load the lower level of granularity of data to fact table.

2277

---

Can we create a Integration service without a Repository service and vice versa?

1217

---

What all are steps in up gradation of Informatica server?

1047

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2013

---

What are the transformations that are not supported in mapplet?

1034

---