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...

who to split dimentions into sub dimention

Answer Posted / kittu

It is clearly apt for snowflake schema because in snow flake schema dimension table are further splits the de-normalized table into small normalized dimensions to decrease the table space and also to increase the performance this can be done with help on foreign key and primary key constraints

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you use flat files in Mapplets.

2646


Where are the source flat files kept before running the session?

1061


What are the tuning techniques you applied during your last project

2018


What is informatica? Why do we need it?

1085


Can informatica load heterogeneous targets from heterogeneous sources?

1174


What are the reusable transformations?

1144


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.

1150


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1029


How to do the error handling of if ur source is flatfiles?

1950


What are the informatica performance improvement tips

1071


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?

1232


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10668


in reporting we add some new objects,how we get the count of the newly added objects to the report

2178


What are the new features of informatica 9.x at the developer level?

1030


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

1062