Answer Posted / sudheer.r

snowflake schema is centrally located fact table .and
surrounded by normalized dimension tables..
in snowflake compare to dimensions and ffact table
dimensions are small.dimensions are more compare to ster
chema .. snow flake shema very dificult to understand ...

What is meta data and system catalog?

2303

---

What are cluster analysis in data warehousing?

1111

---

What is surrogate key? Where we use it? Explain with examples.

1027

---

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

924

---

Explain which are the olap tools available that are supported by oracle?

1009

---

Could any one explain me how to create cascading prompts?

1070

---

What is the data type of the surrogate key?

1006

---

What are steps we have to follow in designing the userfriendly universe?

978

---

How to limit the max no of rows retrieved in the report?

984

---

How to create different types of templates?

987

---

What is difference between query studio and report studio?

1088

---

Define Data Warehousing?

1151

---

Code the tables statement for a single-level (most common) frequency?

932

---

Explain the definition of normalized and denormalized view and what are the differences between them?

927

---

How to drill through from a powerplay cube to reportnet?

939

---