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 prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.)

1 Answers   HCL, Syntel,

---

What is the size of the cube?

0 Answers  

---

what is the difference between querystudio in reportnet and cognos8

0 Answers   CTS,

---

-------------------What is StarShema?

1 Answers   Cap Gemini,

---

What are the differences between cognos 8.2 and cognos 8.4? Please help me..

1 Answers  

---

If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

0 Answers   Wipro,

---

hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........

1 Answers   TCS,

---

What are the components of report net?

0 Answers  

---

hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.

0 Answers  

---

What are the different ways of adding data in Transformer?

3 Answers   Cognos, IBM,

---

What is the report studio?

0 Answers  

---

Use of Text Source Variable in Report Studio?

2 Answers  

---