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 / babu

whether the schema contains in normalized form and data should be redundancy is required then we go for snow flake schema and the dimension table should split into another child table in this situation we go for snowflake schema rather than star schema.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the join problems comes appart from loop,chasm & fan Traps

2061


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1210


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1165


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

988


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

2036


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

2154


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1089


U r project in which stage in implementation?

2460


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1086


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3406


What is the difference in creating filters in designer and business objects?

978


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

2198


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

999


What is aggregate table and aggregate fact table ... Any examples of both?

1003


Which versions are used in the bo dashboard work?

982