Advantages of de normalized data?
Answers were Sorted based on User's Feedback
Answer / bharat kalra
De-normalization is a concept used for fast data retrieval
as it reduces the number of joins to be performed in the
select query.
It's reverse of normalisation as any normalised data base
is optimized for DML operations(insert,update,delete).
Is This Answer Correct ? | 9 Yes | 4 No |
Denormalized data makes data retrieval operation faster and
reliable due to minimum number of joins used for
it.Therefore it improves the performance of the system.
Is This Answer Correct ? | 10 Yes | 5 No |
What is a data warehousing?
How to handle multi value dimensions?
Explain me what is vldb?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What is the difference between snowflake and star schema?
What is data analysis?
WHAT IS FACT LESS FACT TABLE?
Difference between e-r modeling and dimentional modeling?
What is crass reference table?
Explain Association algorithm in Data mining?
Explain what are fact, dimension, and measure?
What is many-to-many dimensional model in datawarehousing ?