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

In star schema dimension and master data table are same.
in extend star schema dimension and master data table are
different.( master data outside the cube and dim..table
inside cube). in star schema we can analyis only 16 angle.
but in ex..star schema we can analyis 16*248 angle.

Master data table uses SID, b'cuse to convert alpha numeric
values to numeric this improves ur process speed.
And also we can analyze the angles in 16X248.

By Gigs
BW Consultant, SAP German.

Is This Answer Correct ?    31 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the minimum no of dimensions in info cube?

1079


Explain table partition?

1009


Which report can you use to monitor change run?

1986


What is authorization processing type?

1904


what is high cardinality tell me brief

1529


How the dimensions are optimized?

952


What are the objects that support documentation?

2004


Give some examples of usage of BW statistics reports?

2073


Explain business blueprint stage. What do you do here?

1045


what is a multiprovider? what are the uses and in which case supposed to be use? difference between bi7.0/bw3.5?

2091


is there is any book that covers all topics of BI 7.0 and the navigation steps for bi 7.0 and pdf of 7

1951


I have a report it taking so much time how can I rectify

1482


In real world when do you recommend aggregate?

2422


What are the components of sap bw system?

994


What is the difficulty you have faced in the BW in your overall experience?we don't want common things,we need some difficult concepts what u have faced(in past Experience)?

1911