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?

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 the difference between connected and unconnected stored procedures?

1084


What are the differences between datamart vs. Reporting cube?

1100


Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

924


Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

965


What is batch processing?

1035


Explain what is power center repository?

1007


Can any one explain the hierarchies level data warehousing.

992


What is operational data store (ods)?

1023


Explain what is cost benefit analysis (cba)?

975


Explain the structure of cold fusion?

1043


Explain what are the various methods of getting incremental records or delta records from the source systems?

969


What is the use of tabular model, tabular sql, tabular reference in real time application?

961


Explain the data type of the surrogate key?

952


What are the different types of schemas used in data warehousing?

952


Explain where do we use semi and non additive facts?

1020