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

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

1188


Can you use flat files in Mapplets.

2710


What is the sequence generator transformation in informatica?

1261


can anyone suggest best free Talend data integration training online

1741


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1331


Can informatica load heterogeneous targets from heterogeneous sources?

1228


Briefly define a session task?

1191


How are the sources and targets definitions imported in informatica designer?

1170


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1305


What are the components of the workflow manager?

1179


What is the use of transformation?

1052


Explain your project of banking domian.

1689


How identifying bottlenecks in various components of informatica and resolving them?

1176


What is incremental aggregation?

1134


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2082