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

Star schema: one fact table is sorrounded by de-normalised
dimension table. In star schema we dont have any extended
dimension tables.
Snow flake schema: one fact table is sorrounded by
ormalised dimension table.In Snowflake schema we can have
extended dimension tables.

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about alerts in bos, under what situation we need to use alerts?

985


Differences between business objects and web intelligence reports?

1126


What would you consider as your biggest achievement and why?

959


Explain about a task that really tested your analytical abilities?

1190


in sap bi we have wad, then why we go for sap bo

3326


what are the day to day activities of BO administrator ?

2972


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4673


how to create metric universe ?

2281


Difference between b.o 5.1 and 6.1b?

1150


How to schedule the report in b.o?

955


How can you first report in Business Objects by using broadcast agent?

3001


Explain what is the difference between business requirement document and use case document.

964


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


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4941


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1468