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

For fast retrieval(to Perform a SELECT Operation)

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1473


What are the transformations that are not supported in mapplet?

999


lookup transformation with screenshots

3983


What is a joiner transformation?

965


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1677


Can we change Dynamic to Static or Persistent cache? If so what happens?

2189


What do you mean by filter transformation?

938


Write the prerequisite tasks to achieve the session partition?

1128


What is InformaticaPowerCenter?

1112


How can we handle two sessions in informatica?

1018


Explain the mapping variable usage example in informatica

1132


In development project what is the process to follow for an etl developer from day1

1696


What is the different lookup cache(s)?

1072


What is meant by lookup transformation?

1084


What is Cognos script editor?

4206