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 is generally included in the data target administrative task?
what is sid for to trasport the object along the land scape:/
Extraction in mm and SD and FI? What is the requirement and name them?
What are tickets.
What are the tools to monitor overall query performance.
How would you optimize the dimensions?
If you are asked to change the way tables are displayed in web reporting how would you do this?
What are the options to calculate result as ? summation?
How the query from BW is used?
You want to see if the execution of a query has been slow or fast. How would you do that?
What are the settings for Reporting?
What are the steps to do the configuring third party (bapi) tools.
In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow.
Apart from r/3, which legacy db you used for extraction ?
Is the user exit common for all data sources?