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.

What is a real-time data warehouse?

1033

---

Explain what are the tasks that loadmanger process will do?

976

---

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5703

---

What is static and local variable?

1076

---

What should I have in mind when building olap solution from scratch?

1055

---

What is a full backup?

1017

---

What is called dimensional modelling?

1182

---

What is partitioning? What are the types of partitioning?

1231

---

What is the difference between static cache and dynamic cache?

1060

---

What are the data types present in bo? What happens if we implement view in the designer n report?

992

---

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

2176

---

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1067

---

What is the use of dimensional modeling in data warehousing?

1048

---

What is the 4 + 1 view model as it relates to system modeling?

1095

---

How can you import tables from a database?

1152

---