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 minimum no of dimensions in info cube?
Explain table partition?
Which report can you use to monitor change run?
What is authorization processing type?
what is high cardinality tell me brief
How the dimensions are optimized?
What are the objects that support documentation?
Give some examples of usage of BW statistics reports?
Explain business blueprint stage. What do you do here?
what is a multiprovider? what are the uses and in which case supposed to be use? difference between bi7.0/bw3.5?
is there is any book that covers all topics of BI 7.0 and the navigation steps for bi 7.0 and pdf of 7
I have a report it taking so much time how can I rectify
In real world when do you recommend aggregate?
What are the components of sap bw system?
What is the difficulty you have faced in the BW in your overall experience?we don't want common things,we need some difficult concepts what u have faced(in past Experience)?