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.

ware house management system is used?

943

---

Explain what is a staging area? Do we need it? What is the purpose of a staging area?

902

---

Fact table is in normalized or de-normalized form?

908

---

Explain what are the advantages data mining over traditional approaches?

1082

---

How to add a number to a macro variable?

940

---

The same tier?

982

---

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

915

---

How can we run the graph? How can we schedule the graph in unix?

883

---

Define Data Warehousing?

1098

---

Explain what is the difference between datawarehouse and bi?

905

---

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

2057

---

What is surrogate key? Where we use it? Explain with examples.

957

---

How to create different types of templates?

928

---

What are the steps involved in creating dimensional modeling process?

951

---

Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

2283

---