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
What are the delta options available when load from flat file?
What are the exits available in HRPTDW01?
hierarchies are not there in bi?why
When you can use the process chain in the data warehouse?
Explain bp master data?
What is scoring ?
When is idoc data transfer used?
In real world when do you recommend aggregate?
What is extraction setup?
I don't have master data it will possible to load transaction data? it is possible is there any other steps to do that one
what is the difference between pdf and excel format after saving the report?
What is bp master data.
What is a temporal join?
What is info provider documentation?
What are the template options?