what is difference between star schema and extend star
schema?
Answer Posted / g k ramesh
1.In star schema the central fact table is surrounded by
master data tables(=dimension tables).since master data
lies with in the cube.we can not reuse the master data
information for other cubes.where as in Extended star
schema the central fact table is surrounded by dimension
tabes(!=master data tables).master data tables lies out
side the info cube.so,we can share the master data
information for other cubes.
2.In star schema the fact table holds Alpha-numaric
information.so,it degrades the database performance and
query performance.where as in Extended star schema using
SID tables we can see all the information in the fact table
as numaric.so,it improves the database performance and
query performance.
3.In star schema the fact table is directly connected to
the master data tables and it can be connected to a maximum
of 16 master data tables.so,we can not analyze the data
more then 16 angles.where as in Extended star schema the
fact table is connect to maximum 16 dimension tables and
each dimension table can be connected to a 248 SID
tables.so we can analyze the data in 16*248 angles
Is This Answer Correct ? | 24 Yes | 8 No |
Post New Answer View All Answers
Can you create a data storage area in the sap bw?
What is Infoset Query?
What are the transaction codes for process chain?
What is SUMRT?
What is compression in the data warehouse?
What are the report-relevant settings in the hierarchy maintenance?
What are the conversion routines for units and currencies in the update rule?
Give an example of it?
what is the ticketing tool for wipro and ticketing tool depends on company or client?
Which report can you use to monitor change run?
What are the load process and processing?
What is the Bex options for characteristics like F4 help for query definition and execution?
What are the proposal options available?
What is the difference between sap bw 3.5 and 7.0?
What are the inputs for an infoset?