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

How can we handle two sessions in informatica?

1091


tell me the rules and responsblites in our project(my project is development)

1974


What is target designer and target load order?

1167


Explain in detail about scd type 1 through mapping.

1627


Explain in detail scd type 2 through mapping.

1088


Slowly changing dimensions, types and where will you use them

1767


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2369


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3921


What is a sorter transformation?

1153


What are the different components of powercenter?

1110


What is aggregator transformation in informatica?

1001


Design time, run time. If you don't create parameter what will happen

1891


Why filter transformation is an active one?

1030


Explain lookup transformation source types in informatica

1151


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1111