Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages of de normalized data?
- 2 Answers
- 11292 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 |
What is drilling across?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What is Active Datawarehousing?
What is ods (operation data source)?
What is an OLTP (Online Transaction Processing) System?
Advantages of de normalized data?
List any five applications of data warehouse.
Can you state some of the innovations throughout history?
How many types of facts and what are they?
What should I have in mind when building olap solution from scratch?
Explain clustering algorithm?
Is there any difference in testing database and data ware housing?
Teradata 
