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 do you understand by the term 'aggregate cache'?

0 Answers  

---

what is loop in frameworkmanager ?

4 Answers   Texas,

---

Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.

3 Answers   iGate,

---

what r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet??

2 Answers   Satyam,

---

Explain about scorecarding?

0 Answers  

---

---

difference between stored procedure and function?

4 Answers   Syntel,

---

please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

0 Answers  

---

what is query subject

7 Answers   IBM, TCS,

---

How to configure the Cognos configurations to work in the Windows 2000 Server machine?

1 Answers   IBM, Infosys,

---

I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos

1 Answers   IBM,

---

Which lifecycle we will use for reporting?

0 Answers  

---

In a Single page we are having 3 list. While running each has to populated in separate page?

2 Answers   TCS,

---