what is difference between star schema and extend star
schema?
Answer Posted / aviroop
Star schema is a special case of snowflake schema. Here,
the fact table is surrounded by dimension master data
tables inside the Cube. Bt its extended schema version
further breaks up the dimension tables of star schema into
dimension Id table and master data table. It simplifies and
increases the database accessibility for other cubes to
make it more robust.
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What are the steps to configure third party (BAPI)?
Explain the display properties?
remodeling is applied only on info cube? why not dso/ods?
Hi, I need to know anything and everything abt datamarts and thier behaviours. Please suggest any links/whitepapers/articles which explain datamarts from scratch. This is required for my admin job at hand. Appreciate your help :)
Give some examples of old LIS and new equivalent LO?
What is CO-PA retraction?
How would you do the archiving cubex.
what is virtual kef figures? what are the uses and in which case supposed to be use?
What is ?filling? of aggregate?
I have 80 queries which query is taking so much time how can you solve it
What is the precaution you should take when archiving?
how to display the date formats for example i hava a year like 2010 to 2011 bu i want to display in report like 2010-11 can u please explain this
What is the importance of 0requid?
How do perform real-time data acquisition in a bw system?
What is occurence