ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories >> Software >> ERP-CRM >> SAP >> Business-Warehouse
 
 
 
Question
what is difference between star schema and extend star 
schema?
 Question Submitted By :: Vrk
I also faced this Question!!     Rank Answer Posted By  
 
Answer
in star schema master data tables are inside the cube.

demerit of star schema
limited analysis is possible since only 16 master data 
table can be accommodated in a cube.  

alpha nummerical values are getting posted in fact table 
that may degrade the perfomence.

master data table cant reuse for any other cubes. 

in ext. star schema

Surrogat id tables are genearated with the activation of  
master data table. based on sids dimention id will genarate 
and the dimention id will get posted in fact table.

so charactorstic value will not be there fact table insted 
did's and kf will be there.

master data table can be re used since its out side of the 
cube. 

3224 master data table can be used in fact table through 
dimention table.
 
5
Binu V. Rajan
 
View All Answers
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com