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

what is the difference b/w star and snowflack schema in
dataware house?

Answer Posted / raghu_nvs

Hi,
Star schema means centralized fact table joined with
different dimension tables.
snow flake schema means centralized fact table joined with
diff dimension tables, and again that dimension tables
joined with another dimension tables.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3580


Explain how many universes can be created in a project?

1066


What Is Snow Flake Schema?

1215


How we drill up week to month?

1078


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?

10901


Explain about a tricky situation for which you found a very simple solution?

1019


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

2131


What is the difference between slice and dice and cross tab report?

1064


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1013


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

2059


Explain 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)?

1070


Explain the difference between detect alias and detect context?

1109


When we use aggregate awareness function in designer?

983


Explain about a task that really tested your analytical abilities?

1256


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1382