What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

0 Answers  

---

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

0 Answers  

---

Explain what are the steps to build the data warehouse?

0 Answers  

---

Difference between DSS & OLTP?

6 Answers   IBM,

---

What are parallel querys and query hints?

0 Answers  

---

I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE

1 Answers   Wipro,

---

how much memory space occupied real time project (roughly)?

0 Answers  

---

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

0 Answers  

---

How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.

1 Answers   IBM,

---

What is recovering sessions?

0 Answers  

---

What is Data purging?

8 Answers   TCS,

---

What is a functional dependency f said to be minimal?

0 Answers  

---