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

How many dimensions are there in informatica?

1134


explan ur project architecture?

2126


Clarify the aggregator change?

1077


What are the different versions of informatica?

1332


What are ETL Tools?

1170


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2403


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1220


What do you mean by channel change?

1105


COM components can be used in Informatica

2450


can anyone suggest best free Talend data integration training online

1741


Describe an informatica powercenter?

1190


Which version configuration tool used in ur project?

3317


Under what condition selecting sorted input in aggregator may fail the session?

1173


Performance tuning in UNIX for informatica mappings?

2623


What is blocking transformation?

1187