Answer Posted / sivakrishna

you can see the data in matrix format in
rolap and molap....

How to pivot data using informatica when you have variable amount of pivot rows?

859

---

What are diagrams?

986

---

How to handle multi value dimensions?

2222

---

How can you implement many relations in star schema model?

938

---

What are the differences between datamart vs. Reporting cube?

1032

---

What is vdl (view definition language) explain?

985

---

Explain datawarehousing?

1001

---

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

903

---

What is load manager?

985

---

Explain the different types of data warehousing?

936

---

How can we do data cleaning?

988

---

ware house management system is used?

944

---

What is a real-time data warehouse?

947

---

Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

916

---

What is meant by metadata in context of a data warehouse and how it is important?

1130

---