Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between star schema and extend star
schema?
- 11 Answers
- 50120 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
What is the procedure to create a data mart?
Which report can you use to monitor change run?
What is a constant selection?
what are the drawbacks of cubes?
How do you convert web objects from 2.x to 3.x?
When is idoc data transfer used?
How can I configure the workflow so that when the deadline is missed the workflow step is simply skipped?
Performance monitoring and analysis tools in bw
What is authorization processing type?
List the steps to do the converting from lis to lo extraction.
what is InfoCube?what are the types and uses and in which Case it suppose to be use?
What is the use of transformation and how the mapping is done in bw?
what is structure in reporting?
Give some examples of queries delivered with BW statistics?
What happens when you use several conditions in a query?
