Advantages of de normalized data?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an er diagram?

638


Where the data cube technology is used?

550


Explain clustering algorithm?

1855


How many project sources we can create in metadata?

561


Is there any difference in testing database and data ware housing?

2276






Can we take backup when the database is opened?

594


What is the difference between datawarehouse and bi?

524


How to pivot row data using informatica?

521


Can you pass sql queries in filter transformation?

541


Explain why fact table is in normal form?

543


What is the difference between mapping parameter & mapping variable in data warehousing?

559


Explain ddl (data definition language)?

580


Explain how to get the first 100 rows from the flat file into the target?

524


How can you import tables from a database?

562


in general which algorithms for used?

1560