what is difference between star schema and extend star
schema?
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 are the sap enhancements to enhance fir data?
Can you name a few important tasks which are essential in the data warehousing and management of the same?
Explain bp master data?
What are the questions could be in client interview?
Performance monitoring and analysis tools in bw
I told my process chains nearly 600 are there he asked me how can u monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see? Any tools are there to see tell me what it is
What are the inputs for an infoset?
What are the options for conditions for key figures?
What is bw statistics and how it is used?
What are the different categories of infoobjects in bw system?
What are nodes?
What is a profitability segment?
What is an infocube?
How to gathering the requirement
What are the advantages of new LO extraction?