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

how many types of variables in cognos report net and cognos 8

4 Answers   HCL, Merrill Lynch,

---

what is session parameters? what is use?

1 Answers   HCL, Satyam,

---

How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?

0 Answers  

---

actually my qus is i used some tables in my model,i published that to connection i use that one.at the same way my team member added some new tables and again he published how can i get my model in connection pls pls explain me..........

1 Answers  

---

what are typees of dimensions

11 Answers   HCL,

---

1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

0 Answers  

---

difference between stored procedure and function?

4 Answers   Syntel,

---

What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.

2 Answers   DELL,

---

It is possible to give 2 query items has measures in cross tab?for ex:row as products,column as year and measure as revenue,sales year....like that.It is possible r not ?If it's possible pls tel me the process....

2 Answers  

---

What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....

4 Answers  

---

what happens when date function has taken as attribute

1 Answers   TCS,

---

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

2 Answers   iFlex,

---