Answer Posted / juff

Star schema fact table is surounded by all the dimension
tables.In Hyperion cube data values of fact table only
stored.

For faster process, what we will do with the universe?

992

---

Is there any difference in testing database and data ware housing?

2762

---

Explain are data mart and dwh normalized or denormalized? Do both of them exist in

1038

---

What are vaious etl tools in the market?

1004

---

Explain what is data validation strategies for data mart validation after loading process?

1030

---

Explain difference between e-r modeling and dimentional modeling?

990

---

How do you setup Lo-cockpit?

3166

---

What are data validation strategies for data mart validation after loading process?

1017

---

Explain the difference between oltp and olap?

1125

---

What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

898

---

Explain why should you put your data warehouse on a different system than your oltp system?

924

---

What is the difference between olap and oltp?

1057

---

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

962

---

How can we load the time dimension?

1199

---

Why should we use data ware housing and how can you extract data for analysis with example?

1000

---