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

What is the use of real-time infocube?

543


Explain business blueprint stage. What do you do here?

649


What is update mode for master data?

1740


When you compressed multiple requests, how would you know which had ?marker update? enabled or not?

1460


How do you debug user exit?

1564






What is the calculated key figure?

610


How can I configure the workflow so that when the deadline is missed the workflow step is simply skipped?

589


I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading

1675


How much time would it take to upload 1 million data to infocube?

611


What is the procedure to create a data mart?

1620


You want to see the log of transport connection. What t-code would you use? List the steps.

622


is it possible to avoid special characteristic in infocube level permanently?

1479


Can you name a few important tasks which are essential in the data warehousing and management of the same?

568


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

1751


What is the difference between sending a mail to a recipient list compared to sending individual mails via a dynamic loop?

589