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
- 8269 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Write types of folders present in cognos?
What is difference between data mart and data warehouse?
What is main advantage datawarehousing over oracle?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What is catalog and types of catalogs in cagonos and which is better?
How to publish a package by running Java Script?
What are the roles defined by cognos platform?
How do you improve the performance of the Cognos Analytics report
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
How do you Parametermap variables in Quiries?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
how can you get the errors in job? when loops are araised we get error?
What is the difference between static and dynamic conditions?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
