Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

What is a hash cluster?

0 Answers  


Can any one explain about core dimension, balanced dimension, and dirty dimension?

0 Answers  


Tell me what is degree of a relation?

0 Answers  


Explain the importance of data warehouse?

0 Answers  


What is a fact, dimension, measure?

0 Answers  


Code the tables statement to produce a multi-level frequency?

0 Answers  


What is Time Series algorithm in data mining?

2 Answers  


What is the metadata extension?

0 Answers  


Explain the definition of normalized and denormalized view and what are the differences between them?

0 Answers  


Difference between cold fusion mx 6 and cold fusion mx 7?

0 Answers  


What is the difference between OLAP, ROLAP, MOLAP and HOLAP?

2 Answers  


What are necessary tasks to install reportnet software?

0 Answers  


Categories