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
Explain bp master data?
What do you mean by the term rollup in the sap bw?
How extended star schema is different from star schema?
You want to see if the execution of a query has been slow or fast. How would you do that?
What is ?filling? of aggregate?
How do you check the alert monitor?
how would you re-assign to proper component?
What is the conversion routine for units and currencies in the update rule?
How do you convert web objects from 2.x to 3.x?
What is geographical information in the sap bw and for what purpose it is used commonly?
What is characteristics derivation?
What is the difference between sap bw 3.0b and sap bw 3.1c, 3.5?
Where the data is extracted during init of delta and during delta updates?
What are the objects that support variables?
What is the use of infocube in bw system?