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
Give an example of CO-PA fields at the operating concern that are not replicated?
How do I separate development from the production environment?
How will you change the default destination of open hub files?
What is the calculated key figure?
Explain web template?
What is a temporal join?
what are the info cube developed in a sap project?name them and what is the requirement?
In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?
What is the purpose of geographical information in the sap bw?
How do you upload currency exchange from a flat file?
what is the component?
List the steps to do the configuring third party (bapi) tools.
What is bp master data.
WHAT IS PBJECT DOCUMENTATION? WHERE YOU CAN DO IT? WHAT IS THE USE OF THAT?
What are the steps to do the extractig data from r/3.