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 the use of dimensional modeling in data warehousing?
What is the difference between er modeling and dimensional modeling?
if you use oracle sql*loader , how do you transform data with it during loading?
Explain what are components of reportnet?
Explain the definition of normalized and denormalized view?
What are the advantages of raid 1, 1/0, and
What is degenerate dimension table?
Can you explain how analysis service works?
Can decision tree be implemented using SQL?
What is XMLA ?
Who needs data warehousing?
DWH architecture?