Answer Posted / sathish arichandran

Each Dimension table has been split into more than one
dimension and connected with centralized fact table. It has
bigger size than star schema. Dimensions are sliced
deeply with the business requirements.

But it is tough to understandable since it has more tables

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

1018

---

How can you communicate with web server (apache or iis) from coldfusion?

1115

---

What is meta data and system catalog?

2298

---

What is "method/1"?

1048

---

What is a real-time data warehouse?

996

---

What we will do with the universe for faster process?

981

---

What is data analysis? Where it will be used?

984

---

What is Operational Data Store?

1070

---

What is difference between model & package?

1029

---

Explain what is the difference between view filter and report filter?

977

---

Define Data Warehousing?

1144

---

Explain can report net connect multiple datasource at a time in report creation time?

921

---

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

1017

---

How to load the time dimension?

1002

---

What are the different types of datawarehosuing?

989

---