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
- 8301 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 |
diff b/w dimension and regular dimension
what is the difference between filter and condition?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
How we check the errors before running the report?
please tell me architecture of the cognos8?
what do u mean by bridge group? where we r using this one?
How to create model and how to test model?
I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?
How can we Maintain the Cube Security by Category level and Dimension level ?
Can you define transformer?
How we check the errors before running the report,plz let me know the answer
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
Teradata 
