Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages of de normalized data?
- 2 Answers
- 11409 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 |
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
What is the difference between view materialized view and view?
Suggest a good author for hyperion in data warehousing?
In microstrategy, how can we direct the sql generated to use a specifc table?
Which component has onread method and what it is used for?
What are the mapping paramaters and maping variables?
What is a Data Warehouse?
Explain what are the modules in power mart?
What are aggregate fact tables ? why they are needed? give an example
Explain what are the tasks that loadmanger process will do?
what is a hot file, why we need in datawarehousing, where we used in general
what are the major three types of modeling used?
0 Answers InfoAxon Technologies,
Teradata 
