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

1473

---

Where the data cube technology is used?

1011

---

What are data modeling and data mining?

1138

---

What is surrogate key? Explain with examples.

1233

---

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

1121

---

What is a real-time data warehouse?

1038

---

Can any one explain about core dimension, balanced dimension, and dirty dimension?

1114

---

How do you define data block size?

1101

---

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?

1122

---

What are the possible data marts in retail sales?

1066

---

What is informatica architecture?

1114

---

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

1013

---

explain about balanced dimension,

1044

---

Briefly state different between data ware house & data mart?

1093

---

What is an error log table in informatica occurs and how to maintain it in mapping?

1008

---