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
- 8291 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
Explain the difference between powerplay transformer and power play reports?
7. What is performance tuning?
What is set to be Cognos configuration?
What is main difference mapplets and mapping?
-----------With out using DrillThrough how to do Reports?
What is looping and how to avoid it in framework manager?
What are products of cognos?
WHAT ARE THE DISTNICT VARIABLES?
What is meant by drill down?
whats the difference between previous version of cognos and cognos 8 BI?
Can you define drill across?
can you tell me what are the dimension tables are used in project
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 r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What is the report studio?
