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
- 8164 Views
- DELL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 9 Yes | 1 No |
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
| Is This Answer Correct ? | 2 Yes | 0 No |
Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance
Can you define cognos powerplay?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
hi, can some one give the information regarding about the best real time project institutes for IBM cognos at ameerpet in hyd
What are the steps to import the two data sources in framework manager?
Explain what is the main advantage of impromptu over cognos reportnet?
what is the difference between group span and level span
How we check the errors before running the report?
can we insert all types of charts in a list report? what r the realtime prompts?
explain project, package ,model , modelers.........and differences b/w them?
How to generate cubes in cognos?
what is cardinality that you can give to employee and department query subjects in framework manager?
Teradata 
