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?

1402


What are value sets?

1528


What is the procedure to create a data mart?

1539


What is the format of LO data sources?

1636


What is the structure of infocube?

525






In update rules for an infocube we can specify separate update rules for characteristics of each of the key figures. In which situations is the above used?

498


When you are using sap bi7.x, you can load the data to which component?

536


What is proposed from statistics for aggregates?

539


What is the table filled when you select ABAP?

1635


What are events and how you use it in BW?

1603


what are the benefits of ods?

564


Is the user exit common for all data sources?

1465


What are value fields?

1403


What is bp master data.

499


You want to see if the execution of a query has been slow or fast. How would you do that?

492