Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages of de normalized data?
- 2 Answers
- 11537 Views
- I also Faced
- E-Mail Answers
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 |
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
what is the difference between DSS and ODS ?
What is cubes?
What is surrogate key?
Explain is olap databases are called decision support system true/false?
Why is business intelligence (bi) important in data warehousing?
What is the difference between connected and unconnected stored procedures?
What is meant by metadata in context of a data warehouse and how it is important?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What is data analysis?
what are different storage options supported by oracle ?
What is type 2 version dimension?
Teradata 
