What is a star schema?
Answers were Sorted based on User's Feedback
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 |
What is SUMRT?
What are the general restrictions?
What is CO-PA retraction?
my intermediate is mpc and my graduation is bcom and pg is mba. learnt sap bw and abap. tell me the interview questions for the same?
Can you define aggregates on time dependent navigational attributes?
What is a restricted key figure and give an example?
What is scoring ?
Define the record modes for delta?
What are the new update methods since PI 2002?
What is the use of the info area in the sap bw system?
What is user entry?
What are the nine decision points of data ware housing?