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

Different qualification between a related rotate toward the sky and isolates look upward?

931


How to load last n records of file into target table - informatica

1022


4 yrs etl devloper roles and responsibilities?any body give solutions

2077


How can you differentiate between powercenter and power map?

1020


How can one identify whether mapping is correct or not without connecting session?

1371


Briefly describe lookup transformation?

982


What is an aggregator transformation?

1032


Enterprise data warehouse your projects phase by phase explain?

1857


What is domain in terms of informatica?

957


Why is sorter an active transformation?

1059


Write the unconnected lookup syntax?

1033


What can we do to improve the performance of informatica aggregator transformation?

1045


Enlist the advantages of informatica.

1007


Explain what is informatica metadata and where is it stored?

989


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2296