Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between star schema and extend star
schema?
- 11 Answers
- 49474 Views
- Accenture, I also Faced
- E-Mail Answers
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 mathematical functions?
What is the calculated key figure?
What is the program to maintain change run?
What is an infoobject and why it is used in sap bi?
What are the different types of infocube?
Is it possible to create aggregates for cumulative?
What is the dimension in bw? How would you optimize the dimensions?
How dashboard is created in sap bw?
Can you tell something about the multi-provider in the sap and how it is useful for the users?
What are the different categories of infoobjects in bw system?
What is the use of db connection in sap bw data acquisition?
What are extractors? Name a few which are used commonly in the sap bw?
Where do you store your custom images (like logos)?
what are the benefits of cubes?
can any one give me a senario for generic data source extraction? why u go for infosets and multiproviders ? give me a senario for each? what is time stamp, calday, numpt? what is safty intervels, y we set lower lt and upper lt?
