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

Star schema is a special case of snowflake schema. Here,
the fact table is surrounded by dimension master data
tables inside the Cube. Bt its extended schema version
further breaks up the dimension tables of star schema into
dimension Id table and master data table. It simplifies and
increases the database accessibility for other cubes to
make it more robust.

Is This Answer Correct ?    7 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

when u creating infoobject it shows reference and template what is it

2725


In real world when do you recommend aggregate?

2484


What is scoring ?

1039


What is data ware-housing hierarchy?

1153


What does rollup do?

1109


Can you add programs in the scheduler?

1145


Does any other erp software use bw for data warehousing.

1034


What is the process chain?

1032


Explain about the multi-provider in the sap?

994


What is delete table before extraction option?

1861


How will you configure BW to load data from data stages?

2057


Explain about ods?

1142


What is the format of LO data sources?

2122


What are the data target administration tasks?

2370


In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow.

1632