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 the difference between a primary and secondary actor in use case modeling?

1013

---

What is ods (operation data source)?

947

---

What is drilling across?

928

---

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

2083

---

What are the different types of schemas used in data warehousing?

899

---

What are cluster analysis in data warehousing?

1049

---

Where do we use semi and non additive facts?

935

---

What is the difference between connected and unconnected stored procedures?

985

---

explain about balanced dimension,

914

---

What is a general purpose scheduling tool?

1020

---

in general which algorithms for used?

1974

---

Explain what are the advantages of query studio compared to report studio?

965

---

Code the tables statement to produce a multi-level frequency?

934

---

What is index awareness in universe?

950

---

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

916

---