Answer / kumar

Star Schema is centally Located by Fact Table surrounded by
Dimension Tables, hence it resembles Star so we call it
as "Star Schema"

Here We use the De-Normalized tables, If we use Normalizewd
tables that prefer the Snow-Flake Schema.

In Star Schema we have the less no. of tables, so we have
the duplicate records with non key attributes.


For further Reference, Please go through the below URL.
http://datawarehouse4u.info/Data-warehouse-schema-
architecture-star-schema.html

Answer / aq

Because, we use Star schema to analyse the data and for that we need fast access of that data.
if the schema is normalized then it will have more joins and will take more time retrieve the data from source, which will cause the reporting / analysis slow.
Hence to faster access of the data Star Schema is de-normalized

What is drill down and slicing and dicing whats the difference between them?

0 Answers  

---

Where do you edit cognos sql in report studio?

3 Answers   HCL,

---

Wht is difference between content store and content manager?

2 Answers   Satyam, Tech Mahindra,

---

what is online view?

0 Answers   HCL,

---

1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

0 Answers   Mphasis, TCS,

---

---

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

0 Answers  

---

suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me

2 Answers  

---

What is the difference between filter & Condition?

4 Answers   IBM, Polaris, TCS,

---

how u create security to reports ????

10 Answers   iFlex, iGate,

---

-----------Diff b/w OLAP and RDBMS?

0 Answers   Bank Of America,

---

How you drill from powerPLay to Impromptu?Explain all Steps?

2 Answers  

---

Can you define materialized view?

0 Answers  

---