Advantages of de normalized data?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

527


What is bi?

565


What is index awareness in universe?

573


Start a batches with in a batch?

549


Explain clustering algorithm?

1846






How to allow a dynamic selection of a column for a measure in a chart,without using variable?

507


Why should we use data ware housing and how can you extract data for analysis with example?

553


What is data cleaning? How can we do that?

553


How are the dimension tables designed?

560


Why facts table is useful in representing the data?

492


How to provide security in frame work manager for a query subject?

519


Why null values are mapped as 0 in fact tables?

528


a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

1922


How can we determine what records to extract?

593


What is surrogate key? Where we use it explain with example?

483