ALLInterview.com :: Home Page            
 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                      
Google
   
 
Categories >> Software >> ERP CRM >> SAP >> Business Warehouse
 
 


 

 
 Basis interview questions  Basis Interview Questions (812)
 ABAP interview questions  ABAP Interview Questions (2426)
 SAPScript interview questions  SAPScript Interview Questions (127)
 SD interview questions  SD Interview Questions (1948)
 MM interview questions  MM Interview Questions (350)
 QM interview questions  QM Interview Questions (8)
 PP interview questions  PP Interview Questions (136)
 PM interview questions  PM Interview Questions (21)
 PS interview questions  PS Interview Questions (20)
 FI CO interview questions  FI CO Interview Questions (1647)
 HR interview questions  HR Interview Questions (434)
 SAP CRM interview questions  SAP CRM Interview Questions (261)
 SRM interview questions  SRM Interview Questions (11)
 APO interview questions  APO Interview Questions (18)
 Business Warehouse interview questions  Business Warehouse Interview Questions (622)
 Business Workflow interview questions  Business Workflow Interview Questions (9)
 SAP Security interview questions  SAP Security Interview Questions (332)
 SAP Interfaces interview questions  SAP Interfaces Interview Questions (4)
 Netweaver interview questions  Netweaver Interview Questions (144)
 SAP ALE IDocs interview questions  SAP ALE IDocs Interview Questions (47)
 SAP B1 interview questions  SAP B1 Interview Questions (57)
 SAP AllOther interview questions  SAP AllOther Interview Questions (90)
Question
what is difference between star schema and extend star 
schema?
 Question Submitted By :: Business-Warehouse
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
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.
 
Is This Answer Correct ?    76 Yes 14 No
Dhalpathi
 
Answer
# 2
In starschema dimensions are not sharable where as in
extended starschema dimension tables are sharable using SID
tables,i.e master data tables are out side the cube and
every characteristic is connected to its corresponding
master data table using surrogate id table.
 
Is This Answer Correct ?    59 Yes 8 No
Latha
 
 
 
Answer
# 3
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 ?    30 Yes 10 No
Gigs
 
Answer
# 4
star schema
1.It can be analysed only in 16 dimensions.
2.Master data is not reusable.
3.performance is degraded because of the alphanumeric
values in the fact table.


Extended Star Schema
1.It can be analysed in 16*248 dimensions.
2.Master data can be reusable as it is not inside the cube.
3.Better performance as there r no alphanumeric values in
the fact table.
 
Is This Answer Correct ?    19 Yes 4 No
Pranith Kumar Chakilam
 
Answer
# 5
1.In star schema the central fact table is surrounded by
master data tables(=dimension tables).since master data
lies with in the cube.we can not reuse the master data
information for other cubes.where as in Extended star
schema the central fact table is surrounded by dimension
tabes(!=master data tables).master data tables lies out
side the info cube.so,we can share the master data
information for other cubes.

2.In star schema the fact table holds Alpha-numaric
information.so,it degrades the database performance and
query performance.where as in Extended star schema using
SID tables we can see all the information in the fact table
as numaric.so,it improves the database performance and
query performance.

3.In star schema the fact table is directly connected to
the master data tables and it can be connected to a maximum
of 16 master data tables.so,we can not analyze the data
more then 16 angles.where as in Extended star schema the
fact table is connect to maximum 16 dimension tables and
each dimension table can be connected to a 248 SID
tables.so we can analyze the data in 16*248 angles
 
Is This Answer Correct ?    22 Yes 8 No
G K Ramesh
 
Answer
# 6
multi language support in extended star schema and also
slowly changing dimensions also supported ,,but in star
schema we dont have this option
 
Is This Answer Correct ?    17 Yes 8 No
Pritam
 
Answer
# 7
In extended star schema Multi Languages is supported,
tracking of history is possible, hierarchical structure is
possible and master data is sharable.
 
Is This Answer Correct ?    15 Yes 10 No
B.aravinda
 
Answer
# 8
a. Use of generated keys(numeric) for faster access.
b. Externa hierarchy
c. Multilanguage support
d. Master data common to all cubes
e. Slowly changing dimension supported.
f. Aggregates in its own table for faster access.
 
Is This Answer Correct ?    12 Yes 7 No
Suprakashmay Nandi
 
Answer
# 9
Star schema is a special case of snowflake schema. Here,
the fact table is surrounded by dimension master data
tables inside the Cube. Bt its extended schema version
further breaks up the dimension tables of star schema into
dimension Id table and master data table. It simplifies and
increases the database accessibility for other cubes to
make it more robust.
 
Is This Answer Correct ?    7 Yes 5 No
Aviroop
 
Answer
# 10
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.
 
Is This Answer Correct ?    13 Yes 19 No
Binu V. Rajan
 

 
 
 
Other Business Warehouse Interview Questions
 
  Question Asked @ Answers
 
What is a line item or degenerate dimensions?   3
Can you do any testing on ODS?   1
What are the T.code using in Production support. briefly explain the use of those code?   2
When should you do the alpha conversion?   4
Define a remote cube?   2
How would you send e-mail when a process ends?   2
What are the steps within SBIW to create classes for BW?   1
What are the options available when you define conditions with respect to characteristics combination?   1
Can you compare the CO-PA to an info cube?   1
What are the advantages of using ODS in a infoset for reporting?   1
I am learning SAP BI.i want learn more about Extraction in Bi.can please provide more info about it.what is the use of Extraction in real time.please provide detailed information about it.   1
What is a template?   1
 
For more Business Warehouse Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com