What is a star schema?

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


Please Help Members By Posting Answers For Below Questions

List the steps to do the creating classes in sap-bw

660


Can you create a data storage area in the sap bw?

668


In update rules for an infocube we can specify separate update rules for characteristics of each of the key figures. In which situations is the above used?

718


What are the do?s and don?ts?

1804


we have a ods in process chain and the ods activation is taking long time how will u optimize the activation process.

6090


Can you give a list of standard web items delivered?

1900


What is the program to maintain change run?

1903


How do you transform OH data?

1654


What is the use ':' as an authorization value?

702


What is the issued with V3 updates prior to PI 2002?

1648


Explain the usage of geo-coordinates ?

726


What is the procedure to implement structural authorization in BW?

1988


How do you access to source system data in bi without extraction?

726


Can you add programs in the scheduler?

774


Explain about the multi-provider in the sap?

660