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

why dimenstion tables are denormalized in nature ?

Answer Posted / ankit kansal

As a denormalized table structures for a database the number
of joins to fetch the data turns out to be less and hence selection to the data becomes faster.

selecting data from one table is always better than selecting the same data from multiple tables.


http://deepinopensource.blogspot.in/

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain why we use partitioning the session in informatica?

1096


What are the new features of informatica 9.x in developer level?

1000


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2252


What are different types of transformations available in informatica?

993


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3872


What is informatica metadata and where is it stored?

993


Write the unconnected lookup syntax?

1084


Explain scd type 3 through mapping.

1021


Enlist the differences between database and data warehouse.

1127


Explain pushdown optimization $pushdownconfig parameter - informatica

1149


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

1180


What is a mapplet/worklet in informatica?

1188


What is the commit type if you have a transaction control transformation in the mapping?

1033


Differentiate between router and filter transformation?

1015


Mention few power centre client applications with their basic purpose?

951