Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between star schema and extend star
schema?
- 11 Answers
- 49472 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / pranith kumar chakilam
star schema
1.It can be analysed only in 16 dimensions.
2.Master data is not reusable.
3.performance is degraded because of the alphanumeric
values in the fact table.
Extended Star Schema
1.It can be analysed in 16*248 dimensions.
2.Master data can be reusable as it is not inside the cube.
3.Better performance as there r no alphanumeric values in
the fact table.
| Is This Answer Correct ? | 20 Yes | 4 No |
Post New Answer View All Answers
What is the program to maintain change run?
what is the include program name?
When you compressed multiple requests, how would you know which had ?marker update? enabled or not?
WHAT IS PBJECT DOCUMENTATION? WHERE YOU CAN DO IT? WHAT IS THE USE OF THAT?
What is 0record mode.
What are the data target administration tasks?
What do you understand by start and update routine?
What is the use of real-time infocube?
How to gathering the requirement
What is the importance of 0requid?
Where do we use infoset in bi system?
How would you do the calling a bw query from an abap program.
What is a control query?
What is the transaction to maintain services?
You want to see the error idocs. Tell the navigation you would use.
