Why Star Schema is de-normalized? Please explain in detail
probably with some examples.
Answer Posted / 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
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
Write some methods to apply securities in framework manager model?
What are the advantages of cognos?
What are all types of Batches?
What is meant by junk dimension?
write a query to display the departments with no employee?
What is a Cube?
What do you understand by the term 'aggregate cache'?
How the Bursting happens in same report and how to Print the bursting Report?
What do you understand by the term 'dynamic cube'?
What are products of cognos?
What is drill down and slicing and dicing whats the difference between them?
What is cognos reporting tool?
Explain what is the difference between microstrategy and cognos reporting tool?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com