Answer Posted / pratap gangula

Hi Marcelo,

The retrieval procedure is different because the storage model is different so ultimately the main difference between ROLAP and MOLAP is still in the storage concepts. While designing DW we dont decide whether the requirement is to fetch the data using SQL or MDX....rather we focus on whether the need for storing the data is in RDBMS format or Multidimensional format .

What are loops in Datawarehousing?

1000

---

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

1009

---

Explain what is data validation strategies for data mart validation after loading process?

1030

---

Explain the versions of reportnet?

990

---

What is vdl (view definition language) explain?

1043

---

What is the difference between dependent data warehouse and independent data warehouse?

1007

---

What are the steps to build the datawarehouse?

1040

---

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2050

---

What is Sequence clustering algorithm?

2029

---

What are session timeout and application timeout? Where we have to do this process?

1044

---

if you use oracle sql*loader , how do you transform data with it during loading?

2100

---

What are modeling tools available in the market?

978

---

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1099

---

How to create diff. Types of templates?

1050

---

What is scd1 , scd2 , scd3?

1088

---