Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between star schema and extend star
schema?
- 11 Answers
- 49471 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / binu v. rajan
in star schema master data tables are inside the cube.
demerit of star schema
limited analysis is possible since only 16 master data
table can be accommodated in a cube.
alpha nummerical values are getting posted in fact table
that may degrade the perfomence.
master data table cant reuse for any other cubes.
in ext. star schema
Surrogat id tables are genearated with the activation of
master data table. based on sids dimention id will genarate
and the dimention id will get posted in fact table.
so charactorstic value will not be there fact table insted
did's and kf will be there.
master data table can be re used since its out side of the
cube.
3224 master data table can be used in fact table through
dimention table.
| Is This Answer Correct ? | 13 Yes | 19 No |
Post New Answer View All Answers
what are the extractions made in a sap bw project using lo cockpit extraction in mm and sd and fi?what is the requirement and name them?
what is meant by compounding attribute tell me the scenario?
What are the steps to configure third party (BAPI)?
What is the use of infoarea in sap bw system?
What are the added features in 3.x for multi provider?
What are the parameters available in user exit for enhancing master data?
What is a constant selection?
What exactly do you know about the sap bw?
Explain the structure of direct update dso?
Give some examples of queries delivered with BW statistics?
What is the alpha check execution program?
Explain the display properties?
List the steps to configure sd and mm for bw.
What are the types of reports you can use in reporting agent?
What are the different categories of infoobjects in bw system?
