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

what is the size of your data warehousing?

2096


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1907


What do think which one is the better joiner or look up?

1204


Enterprise data warehouse your projects phase by phase explain?

1924


What is a code page?

1181


What does command task mean?

1155


How can you increase the performance in joiner transformation?

1193


What are the types of data warehouses?

1527


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1956


How can we remove the duplicates from flat file source?

1041


What is rank transformation?

991


What is a router transformation?

1132


How big was your fact table

1804


What are the static cache and dynamic cache in informatica?

1195


What is the difference between source qualifier transformations source filter to filter transformation?

1058