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                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Business Objects
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
what is the difference b/w star and snowflack schema in 
dataware house?
 Question Submitted By :: Zeeshan
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the difference b/w star and snowflack schema in dataware house?
Answer
# 1
star schema is nothing but one fact table that is
associating with different dimension tables.
 
Is This Answer Correct ?    3 Yes 5 No
Pp
 
  Re: what is the difference b/w star and snowflack schema in dataware house?
Answer
# 2
Star schema is a schema where the data is in normalized 
form and snow-flake star schema the data is in 
de-normalized form
 
Is This Answer Correct ?    1 Yes 14 No
Bhushanam
 
 
 
  Re: what is the difference b/w star and snowflack schema in dataware house?
Answer
# 3
i think ur answer is swap to both. star is
denormalised,snowflake is normalised.
 
Is This Answer Correct ?    8 Yes 0 No
Simha
 
  Re: what is the difference b/w star and snowflack schema in dataware house?
Answer
# 4
Star schema: one fact table is sorrounded by de-normalised 
dimension table. In star schema we dont have any extended 
dimension tables.
Snow flake schema: one fact table is sorrounded by 
ormalised dimension table.In Snowflake schema we can have 
extended dimension tables.
 
Is This Answer Correct ?    6 Yes 0 No
Shekar
 
  Re: what is the difference b/w star and snowflack schema in dataware house?
Answer
# 5
Star Schema : Star Schema is a relational database schema
for representing multimensional data. It is the simplest
form of data warehouse schema that contains one or more
dimensions and fact tables. It is called a star schema
because the entity-relationship diagram between dimensions
and fact tables resembles a star where one fact table is
connected to multiple dimensions. The center of the star
schema consists of a large fact table and it points towards
the dimension tables. The advantage of star schema are
slicing down, performance increase and easy understanding of
data.

Snowflake Schema : A snowflake schema is a term that
describes a star schema structure normalized through the use
of outrigger tables. i.e dimension table hierachies are
broken into simpler tables.

In a star schema every dimension will have a primary key.
# In a star schema, a dimension table will not have any
parent table.
# Whereas in a snow flake schema, a dimension table will
have one or more parent tables.
# Hierarchies for the dimensions are stored in the
dimensional table itself in star schema.
# Whereas hierachies are broken into separate tables in snow
flake schema. These hierachies helps to drill down the data
from topmost hierachies to the lowermost hierarchies.
 
Is This Answer Correct ?    2 Yes 0 No
Sreenivas
 
  Re: what is the difference b/w star and snowflack schema in dataware house?
Answer
# 6
The difference is in dimension tables and not the fact 
table. Star schema contains denormalized dimension tables 
while snowflake schema contains normalized dimension 
tables, ie dimension tables are extended in snowflake 
schema.
 
Is This Answer Correct ?    1 Yes 0 No
Buttguru
 
  Re: what is the difference b/w star and snowflack schema in dataware house?
Answer
# 7
Star schema is one fact table in the middle is sorrounded 
by many dimension tables and no extenssion for the dimensin 
table it means denormalized.
Snowflake schema is where the dimension table is extended 
to normalized form
 
Is This Answer Correct ?    1 Yes 0 No
Thava
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
Instead of cms which server you have to use? CTS2
How to create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".  2
What are universe parameters?  4
Types of universes in business objects? TCS9
in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.  3
How can you check the universe?  3
What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function Deloitte2
Can anybody tell How a report will burst into .pdf files? Thanks in advance .....Prakash  2
what is a filter?  3
How to Shedule the reports in Xi R2 iFlex3
What is security domain in Business Objects? Polaris4
what is fantrap ? Tech-Mahindra3
how many user were there  1
what r the universe connection types?  2
what is master-detail report TCS2
I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it? IBM1
whats the Diffrerence between business objects and cognos?  1
how can we overcome by loops?and also is it possible ,one user can different universe  4
how did u give developed universe to ur client?  1
Is it possible to develop reports without Universe access? IBM5
 
For more Business Objects Interview Questions Click Here 
 
 
 
 
 
   
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