Answer Posted / anonymous

data mart-A Data Mart is a specific, subject oriented,
repository of data designed to answer specific questions
for a specific set of users. So an organization could have
multiple data marts serving the needs of marketing, sales,
operations, collections, etc. A data mart usually is
organized as one dimensional model as a star-schema (OLAP
cube) made of a fact table and multiple dimension tables.


data warehouse-In contrast, a Data Warehouse (DW) is a
single organizational repository of enterprise wide data
across many or all subject areas. The Data Warehouse is the
authoritative repository of all the fact and dimension data
(that is also available in the data marts) at an atomic
level.

What is a fact, dimension, measure?

1209

---

Can you brief about the Data warehouse project you worked on?

2378

---

How to drill through from a powerplay cube to reportnet?

939

---

What is the difference between view filter and report filter?

925

---

Explain how many ways you create ports?

1024

---

What are the different types of datawarehosuing?

993

---

What is core dimension?

1061

---

Explain a linked cube?

958

---

Explain how to export mappings to the production environment?

977

---

Explain why denormalization is promoted in universe designing?

961

---

Whether dimension table can have numeric value?

1151

---

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1973

---

Explain what is the difference between stop and abort?

1045

---

Describe the differences between a data warehouse and data mart.

1001

---

What are the main steps to build the data warehouse?

1119

---