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

Explain what is real time data-warehousing?

589


What is a data profile?

575


What is a linked cube?

539


What is the difference between dependent data warehouse and independent data warehouse?

607


What is hybrid slowly changing dimension?

628






i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

1589


What is static and local variable?

563


What is the difference between agglomerative and divisive hierarchical clustering?

654


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

1951


What is the difference between datawarehouse and bi?

524


Is there any default username & pwd for bo designer & supervisor?

578


What is the difference between filter and lookup transformation?

618


What are the steps involved in creating dimensional modeling process?

567


What is Sequence clustering algorithm?

1548


Where the applications and where ware house management system is used?

540