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

Discuss the advantages & Disadvantages of star & snowflake
schema?

Answer Posted / hania

Star Schama : easy for users to understand, optimize navigation and more suitable for query processing, and works faster.

Disadvantages: Dimension table have greater rows, large fact table

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

3870


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

1901


Differentiate between router and filter transformation?

1012


How many input parameters can exist in an unconnected lookup?

1545


Explain why we use partitioning the session in informatica?

1090


How can we improve session performance in aggregator transformation?

1117


What is a sorter transformation?

1102


What are the different versions of informatica?

1272


What are the types of schemas we have in data warehouse.

961


What do mean by local and global repository?

1226


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2000


What is the difference between informatica 7.0 and 8.0?

1014


What is option by which we can run all the sessions in a batch simultaneously?

1141


How to convert multiple rows to single row (multiple columns) in informatica

1378


What is joiner change?

1146