Answer Posted / prasant tripathy

Hi

star schema takes more space then the snowflake because
star schema is denormalised schema and snowflake is
normalised

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

964

---

Explain how many ways you create ports?

1024

---

Whether dimension table can have numeric value?

1159

---

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

986

---

What is real-time datawarehousing?

1028

---

What is difference between e-r modeling and dimensional modeling?

929

---

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1387

---

Explain the different types of data warehousing?

993

---

What are fact, dimension, and measure?

1337

---

What is data validation strategies for data mart v?

1092

---

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

2225

---

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

933

---

Explain what are the various file formats involved in reportnet?

944

---

What is vldb(very large databases)?

1016

---

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

1022

---