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 can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?

1 Answers   HCL, iGate,

---

is there any difference between operational database and data base?if yes what r they?

0 Answers  

---

does query is created for date prompt?

9 Answers  

---

at what level u prepared the reports in cognos???? in dataware housing what is the automation tool u r using???

1 Answers   Covansys, IBM, Wipro,

---

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

2 Answers  

---

what is the use of macros&folders&herarchies in frameworkmanger?

1 Answers  

---

What is model filter?

0 Answers  

---

Write some methods to apply securities in framework manager model?

0 Answers  

---

Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?

0 Answers  

---

In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.

4 Answers   Accenture, HCL, IBM,

---

how to merge 2 crosstabs thans

0 Answers   HCL,

---

What do you mean by query studio?

0 Answers  

---