what is difference between star schema and extend star
schema?
Answers were Sorted based on User's Feedback
Answer / binu v. rajan
in star schema master data tables are inside the cube.
demerit of star schema
limited analysis is possible since only 16 master data
table can be accommodated in a cube.
alpha nummerical values are getting posted in fact table
that may degrade the perfomence.
master data table cant reuse for any other cubes.
in ext. star schema
Surrogat id tables are genearated with the activation of
master data table. based on sids dimention id will genarate
and the dimention id will get posted in fact table.
so charactorstic value will not be there fact table insted
did's and kf will be there.
master data table can be re used since its out side of the
cube.
3224 master data table can be used in fact table through
dimention table.
Is This Answer Correct ? | 13 Yes | 19 No |
When you define aggregates, what are the available options?
What is write optimized dso?
What is a controlling area?
What are the different types of infocube?
I am learning SAP BI.i want learn more about Extraction in Bi.can please provide more info about it.what is the use of Extraction in real time.please provide detailed information about it.
What is the difference between ods and info-cubes?
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 :)
describe how you have used excel as a compliment to bex?
Is it possible to cancel the "collapse" process in Process chain. if yes. Briefly expalin how to cancel the process.
What are the minimum no of dimensions in info cube?
Which transaction can you use to get current statistics data?
What are characteristics values?