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...

What are the Advantages of de normalized data?

Answer Posted / kris

De Normalised Data:

A table storing denormalised data occupies more space
because lot of duplicate information creeps in when we
denormalise a table.

As less number of join conditions are required to retrieve
data from one/more denormalised tables, the performance
will be fast.

DWH environment prefers denormalised data structures.

Is This Answer Correct ?    27 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which files are created during the session rums by informatics server?

1124


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1977


tell me the rules and responsblites in our project(my project is development)

1875


What do you mean by worklet?

1018


What are data-driven sessions?

1145


What is joiner transformation in informatica?

995


How many number of sessions can one group in batches?

1097


How many ways a relational source definition can be updated and what are they?

956


Can we change Dynamic to Static or Persistent cache? If so what happens?

2152


How can a transformation be made reusable?

1079


What is a snowflake schema?

927


How to join three sources using joiner? Explain though mapping flow.

1092


Quickly characterize reusable change?

1061


What does role playing dimension mean?

999


What is complex mapping?

1069