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.

Explain what is the difference between stop and abort?

1024

---

Explain what is the difference between view filter and report filter?

964

---

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

2094

---

What is the difference between constraind base load ordering and target load plan?

1101

---

What is the difference between snowflake and star schema?

1030

---

Explain difference between e-r modeling and dimentional modeling?

967

---

What is partitioning? What are the types of partitioning?

1139

---

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1087

---

What is the data type of the surrogate key?

986

---

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

942

---

What are the various methods of getting incremental records or delta records from the source systems?

913

---

Explain about core dimension,

968

---

How can we load the time dimension?

1180

---

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1943

---

explain about balanced dimension,

960

---