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

Suppose we do not group by on any ports of the aggregator what will be the output?

981


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

1931


What is the use of source qualifier?

1069


Explain direct and indirect flat file loading (source file type) - informatica

1261


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2508


What is an aggregator transformation?

1029


How does a rank transform differ from aggregator transform functions max and min?

1143


Write the program through which the records can be updated?

935


how many types of dimensions are available in informatica?

996


Describe expression transformation?

1044


Enlist the differences between database and data warehouse.

1032


Can we create multiple integration service on single repository?

1132


How to elaborate tracing level?

1117


Explain Dataware house architecture .how data flow from intial to end?

2525


what is informatica metadata?

974