Interested to Buy Any Domain ? << Click Here >> for more details...
Why Star Schema is de-normalized? Please explain in detail
probably with some examples.
- 2 Answers
- 8186 Views
- DELL, I also Faced
- E-Mail Answers
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 ?
What do you understand by the term 'aggregate advisor?'
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 ?
What are the types of folder present in cognos?
How security is concerned with Reportnet? Explain its implementing steps.
What do you mean by query studio?
What are slice and dice?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
What are the components of report net?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
How create measures and dimensions?
What is the size of the cube?
How can you link a query to a data container manually in Report Studio?
What do you understand by the term 'aggregate cache'?
What is the difference between set functions and filter function in dimensional data?
