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

1387

---

Where the data cube technology is used?

960

---

What are data modeling and data mining?

1086

---

What is surrogate key? Explain with examples.

1158

---

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

1061

---

What is a real-time data warehouse?

998

---

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

1056

---

How do you define data block size?

1048

---

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?

1072

---

What are the possible data marts in retail sales?

999

---

What is informatica architecture?

1066

---

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

959

---

explain about balanced dimension,

983

---

Briefly state different between data ware house & data mart?

1051

---

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

966

---