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
- 8131 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 |
wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB REPORT?
3. What was the size of your cube?
what are the dimensions that you have in your current project?list them?
is there any difference between operational database and data base?if yes what r they?
What is value prompt limitations while creating report? What is select and search prompt?
how you create security to cubes ?????
what is prompt variable
Which service handles requests for cognos connection,query studio and event studio.
What is a Framework manager?
Can any one tell me cognos training class in chennai? thanks in advance...
how to hide a particular pages at time if you get blank pages
----------------Diff b/w Dimensional modeling and Relational modeling?
Teradata 
