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

Describe the new BW 3.x authorizations?

2042


What is the issued with V3 updates prior to PI 2002?

1908


What happens when you use several conditions in a query?

1920


How would you change the default template?

2071


What is ?User master comparison? in roles?

2037


What is the source for FIAR extractor from R/3?

2210


What is geographical information in the sap bw and for what purpose it is used commonly?

1030


What are the versions in objects?

2070


What are the steps within sap bi to create classes for bw?

1010


How does delta update mechanism work in ods?

1008


what are the drawbacks of cubes?

1048


What are value fields?

1875


How does a navigational attribute differ from other attributes in terms of linking it with the infocube?

925


How do you install business content AWB?

2261


Explain the architecture of the sap bw system and its components?

960