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

Differences between business objects and web intelligence reports?

1295


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

1574


How to schedule the report in b.o?

1098


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2147


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2384


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

3426


What is the difference between absolute and relative div positioning?

1095


How to open a universe with out using the Designer ??

7721


Explain how many universes can be created in a project?

1109


U r project in which stage in implementation?

2574


Which versions are used in the bo dashboard work?

1093


Explain which versions are used in the bo dashboard work?

1125


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

2040


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

2080


When we use aggregate awareness function in designer?

1018