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

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1093


What are the types of data warehouses?

1528


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2462


What is the function of look up transformation?

1126


Enlist the differences between database and data warehouse.

1127


What are junk dimensions?

1076


Is it possible to create multiple domains on a single Informatica server?

1248


What is a code page?

1182


What is main use of mapplet?

1136


COM components can be used in Informatica

2397


What do you mean by channel change?

1052


what is the difference between informatica6.1 and infomatica7.1

2283


How can we remove the duplicates from flat file source?

1045


Differences between connected and unconnected lookup?

1224


How can we use mapping variables in informatica? Where do we use them?

1208