Advantages of de normalized data?

Answers were Sorted based on User's Feedback



Advantages of de normalized data?..

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

Advantages of de normalized data?..

Answer / samir kumar sahoo

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

Post New Answer

More Data Warehouse General Interview Questions

Explain what are the mapping paramaters and maping variables?

0 Answers  


where exactly in dataware house a confirmed dimension can be created

4 Answers   Deloitte,


Can you brief about the Data warehouse project you worked on?

0 Answers   Deloitte, TCS,


What is power play plug in?

3 Answers  


How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

0 Answers  






What is the difference between a data warehouse and a data mart?

15 Answers   Apex, ASD Lab, Bank Of America,


What are Aggregate tables?

0 Answers  


What is dimension modeling?

0 Answers  


Store (and count) non-fact records?

0 Answers  


Difference between ODS and Staging

4 Answers   HeadStrong, TCS,


What are the differences between star and snowflake schema?

0 Answers  


what role views play in dimensional modeling?

1 Answers   TCS, Zensar,


Categories