what is difference between star schema and extend star
schema?
Answer Posted / gigs
In star schema dimension and master data table are same.
in extend star schema dimension and master data table are
different.( master data outside the cube and dim..table
inside cube). in star schema we can analyis only 16 angle.
but in ex..star schema we can analyis 16*248 angle.
Master data table uses SID, b'cuse to convert alpha numeric
values to numeric this improves ur process speed.
And also we can analyze the angles in 16X248.
By Gigs
BW Consultant, SAP German.
Is This Answer Correct ? | 31 Yes | 10 No |
Post New Answer View All Answers
describe how you have used excel as a compliment to bex?
What are the questions could be in client interview?
what is the difference between pdf and excel format after saving the report?
What are the other BW processes?
What is info provider documentation?
What are the general services supported?
explain return tables. How do start routine and return table synchronize with each other?
What is rowlevel security ? can u please explain with real time example?
Where do we use write optimized dso?
What is data ware-housing hierarchy?
Define the Lis data flow?
What is customization.
how would you re-assign to proper component?
What are Process Chains?
What is an infoobject and why it is used in sap bi?