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

What is difference between webi and infoview?

1227


Can you please send me the migration related issues .

2063


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

1500


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

2252


What is a bo repository?

1032


What is the difference between the public object&schema object?

1048


What is the difference between absolute and relative div positioning?

1025


Can we Save (save as) WEBI Doc as DESKI?

8129


What we need to discuss with designer before starting the universe designing.

2229


What is difference between custom hierarchy and report based hierarchy?

992


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

2085


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

985


Explain is there any default username & pwd for bo designer & supervisor?

987


Differences between business objects and web intelligence reports?

1194


What is a fantrap in business objects?

1157