Answer Posted / narasa
Star shcema is one of the Cube Structure.
Fact table surounded by several Dimention tables.
in star schema some imp points.
1. in star schema master data tables and dimention tables
are one and same.
2. Dim tables are linked with fact table. fact table having
a key figures.
3. in we can see the data only in 16 angles only.
4.there is no reusability of dim tables.
and also some are futures and defects also there. these are
little.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the read mode in generic navigation block web item- read mode specifies
Is it possible to convert a standard infocube to real time infocube?
When you are using sap bi7.x, you can load the data to which component?
What are the data sources supported?
What are the server related tuning?
What is the Bex options for characteristics like F4 help for query definition and execution?
as you said you have worked on cubes and ods, which one is better suited for reporting? Explain and what are the drawbacks and benefits of each one?
What is extended star schema? Which of the tables are inside and outside cube in an extended star schema?
wt is difference between user group and reference user group?
what is the data model and how it is use ?
Hi friends gm to all , i had done bi with integrating planning. and I have full knowledge on integrating planing, but I don't faced any interview's in ip now, So friends have we any interview questions like Integrating planning, pls send my mail ID.
What are the sap enhancements to enhance fir data?
What is SAP exit?
How the dimensions are optimized?
What is the use of infoarea in sap bw system?