what is difference between star schema and extend star
schema?
- 11 Answers
- 46120 Views
- Accenture, I also Faced
- E-Mail Answers
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
How the query from BW is used?
What is the use of real-time infocube? How do you enter data in real-time infocubes?
When we use condition the totals do not match why?
When is idoc data transfer used?
R/3 extraction failed - recovery procedure? R/3 extraction is running from past 2 years. Suddenly it failed since 5 days and again today it is running fine. But how i do get data loaded to cube for failed loads? What are the procedures that can be followed?
Explain multiprovider?
When to virtual providers based on dtp?
What is an event chain?
What are the pre-requisites of DB connect?
Does it have delta facility?
When you can use the process chain in the data warehouse?
How do you add an entry in the monitor log from the update rules?
What is the format of LO data sources?
What internally happens when bw objects like info object, info cube or ods are created and activated?
what is the call sequence?
