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 difference between star schema and extend star
schema?

Answer Posted / binu v. rajan

in star schema master data tables are inside the cube.

demerit of star schema
limited analysis is possible since only 16 master data
table can be accommodated in a cube.

alpha nummerical values are getting posted in fact table
that may degrade the perfomence.

master data table cant reuse for any other cubes.

in ext. star schema

Surrogat id tables are genearated with the activation of
master data table. based on sids dimention id will genarate
and the dimention id will get posted in fact table.

so charactorstic value will not be there fact table insted
did's and kf will be there.

master data table can be re used since its out side of the
cube.

3224 master data table can be used in fact table through
dimention table.

Is This Answer Correct ?    13 Yes 19 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I don't have master data it will possible to load transaction data? it is possible is there any other steps to do that one

2686


What are tickets.

957


What is persistence mode in cache?

2213


What is the procedure to implement structural authorization in BW?

2323


What is the option of ?pause Automatic Refresh??

2143


Give examples of data sources that support remote cubes?

2067


What are the destination target options?

2048


what are the info cube developed in a sap project?name them and what is the requirement?

2861


I have a process chain is running the infopackage get error don't process the error of that info package and then you can run the dependent variants is it possible?

1622


What is rowlevel security ? can u please explain with real time example?

2192


WHAT IS PBJECT DOCUMENTATION? WHERE YOU CAN DO IT? WHAT IS THE USE OF THAT?

2150


What are the steps in general to enhance data?

2066


Where do you store your custom images (like logos)?

2450


How do you do Currency translation in SAP BW ?What are the settings that needs to be done?

1148


R/3 extraction failed - recovery procedure? R/3 extraction is running from past 2 years. Suddenly it failed since 5 days and again today it is running fine. But how i do get data loaded to cube for failed loads? What are the procedures that can be followed?

2720