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
What are all the types of indexes in Cognos?
Can you define pivot?
7. What is performance tuning?
Can you define framework manager?
What are the types of security?
how to connect datamarts
What is the difference between group and associare?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
What are all types of Batches?
Can you define bitmap index?
What is meant by alternate drill down with ex?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What are query items?