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 / vikki

GENERALLY IN DWH, WE DO SELECT QUERY ONLY(99%)..
SO THE DATA ARE NOT NEED TO BE NORMALIZED AS IN DB WHERE WE DO UPDATE,SELECT,ALTER,ETC..

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the impact of several join conditions and join order in a joiner transformation?

1048


What is the surrogate key?

1234


What are the performance considerations when working with aggregator transformation?

1133


What are some examples of informatica etl programs?

919


What are the steps involved in the migration from older version to newer version of Informatica Server?

2091


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1986


can anyone explain me about retail domain project in informatica?

7929


What is the meaning of up gradation of repository?

1959


How to create or import flat file definition in to the warehouse designer?

1059


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1033


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1068


Why is sorter an active transformation?

1101


How can you increase the performance in joiner transformation?

1181


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1058


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1074