what is difference between star schema and extend star
schema?

Answer Posted / gigs

In star schema dimension and master data table are same.
in extend star schema dimension and master data table are
different.( master data outside the cube and dim..table
inside cube). in star schema we can analyis only 16 angle.
but in ex..star schema we can analyis 16*248 angle.

Master data table uses SID, b'cuse to convert alpha numeric
values to numeric this improves ur process speed.
And also we can analyze the angles in 16X248.

By Gigs
BW Consultant, SAP German.

Is This Answer Correct ?    31 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the delta options available when load from flat file?

558


What are the exits available in HRPTDW01?

2236


hierarchies are not there in bi?why

1226


When you can use the process chain in the data warehouse?

480


Explain bp master data?

508






What is scoring ?

554


When is idoc data transfer used?

578


In real world when do you recommend aggregate?

1900


What is extraction setup?

1592


I don't have master data it will possible to load transaction data? it is possible is there any other steps to do that one

1923


what is the difference between pdf and excel format after saving the report?

6009


What is bp master data.

521


What is a temporal join?

556


What is info provider documentation?

1989


What are the template options?

1641