Answer Posted / p.d.vijay kumar

ROLAP
ROLAP stands for Relational Online Analytical Process that
provides multidimensional analysis of data, stored in a
Relational database(RDBMS).
MOLAP
------
MOLAP(Multidimensional OLAP), provides the analysis of data
stored in a multi-dimensional data cube.
HOLAP
------
HOLAP(Hybrid OLAP) a combination of both ROLAP and MOLAP can
provide multidimensional analysis simultaneously of data
stored in a multidimensional database and in a relational
database(RDBMS).
DOLAP
-----
DOLAP(Desktop OLAP or Database OLAP)provide multidimensional
analysis locally in the client machine on the data collected
from relational or multidimensional database servers.

Explain what is real time data-warehousing?

1104

---

What is data cleaning? How can we do that?

1044

---

What is drilling across?

994

---

What is the use of dimensional modeling in data warehousing?

986

---

What is the purpose of cluster analysis in data warehousing?

1008

---

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

994

---

Is there any rownum object from which we can do this?

945

---

What is the difference between ods and oltp?

1021

---

Why denormalization is promoted in universe designing?

987

---

Explain how to generate iqd file from framework manager?

946

---

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2271

---

What are partition points?

1073

---

Explain about core dimension, balanced dimension, and dirty dimension?

1009

---

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1956

---

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

975

---