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

when we go for snow flake schema rather than star schema ?

Answer Posted / murali

snow flake schema is used for the dim tables contains more fields and the Dim_DB Tables are in the Normalization form.

Draw-back: Slow performance for executing the query.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between datawarehousing and businessintelligence?

1098


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

2117


Can you please send me the migration related issues .

2073


how to prepare the documentation in business objects and where to get the requirement?

2222


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2395


Explain how we drill up week to month?

1092


Differences between business objects and web intelligence reports?

1222


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10891


Can we configure two instances of CMS pointing to two different CMS system databases?

2031


What is the difference between business requirement document and use case document.

1007


Explain what three things do you consider to be the most important factors for a manager?

1008


Explain what task is 98% of the required work of a business analyst?

1103


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1883


What is the difference between user and versatile user?

1071


Can anybody tell me what are the tuning problems?

2044