Answer Posted / rams

Independent Data Mart Dependent Data Mart
1) it won't have 1) it will share the common dimension
shared Dimension
2) perfect Data mart 2) it's a Enterprise DW

Explain degenerate dimension table?

1101

---

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

992

---

Briefly state different between data ware house & data mart?

1085

---

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

1284

---

Why should we use data ware housing and how can you extract data for analysis with example?

1042

---

How to performance tune reports?

1257

---

Explain hybrid slowly changing dimension?

1062

---

What are session timeout and application timeout?

1059

---

Define Data Warehousing?

1198

---

Explain differences between star and snowflake schemas?

1235

---

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

2437

---

Describe the differences between a data warehouse and data mart.

1062

---

What does level of granularity of a fact table signify?

1151

---

Where the applications and where ware house management system is used?

1054

---

Explain why should you put your data warehouse on a different system than your oltp system?

987

---