what is difference between star schema and extend star
schema?

Answer Posted / latha

In starschema dimensions are not sharable where as in
extended starschema dimension tables are sharable using SID
tables,i.e master data tables are out side the cube and
every characteristic is connected to its corresponding
master data table using surrogate id table.

Is This Answer Correct ?    69 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you use print settings?

1412


What are the options for hierarchy node variables?

1552


What is the transaction to maintain services?

1482


Is it possible to convert a standard infocube to real time infocube?

550


What is a repair request?

1515






What is infoobject otpauth?

521


What is sap bw/bi?

582


What is the benefit of using bw reporting over sap reporting?

510


What are Process Chains?

532


what is the call sequence?

1634


What are the options for conditions for key figures?

1448


How many types of info sources are there? What are they?

1656


How would you change the default template?

1545


What are the settings for Reporting?

1622


What is write optimized dso?

577