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

How is an Extended star schema of BW more advantageous than
the star schema?

Answer Posted / gireesh

1. star schema does not support hierarchy but extended star schema support hierarchy.
2. master data redundency in star schema and in extended star schema there is no masterdata redundancy.
3. In extended star schema master data devided in 3 categories that is
1. md text data
2. md attribute data
3. md hierachy data

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an event chain?

1058


What are transfer rules?

941


What are tickets.

962


Explain the structure of direct update dso?

1069


What are the system tools you can use?

2129


What is Infoset Query?

1029


What internally happens when bw objects like info object, info cube or ods are created and activated?

1075


Where do we use infoset in bi system?

962


What do you understand by start and update routine?

973


Do you have any idea how to improve the performance of the bw?

926


hierarchies are not there in bi?why

1728


where can we find transport return codes

1496


What is start routines.

963


How does delta update mechanism work in ods?

1015


What are the options when defining aggregates?

2871