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       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
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
 
bo 6.5 is a 3 tier architecture. Tell me the names of the tiers? TCS5
How many tables can an universe contain is their any limit to insert tables in the universe?  3
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level Accenture2
Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example IBM1
WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY?  1
'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.  1
how to hide the prompts? TCS6
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?  2
what is maximum scope of analysis --> can we define more than 3 levels? CTS1
What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function Deloitte2
1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?  2
who r the users in B.O.XIR2? PCS2
WHAT KIND OF TOOL BO IS?  5
difference between xir2 and 6.5 version  4
why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question. Satyam5
what is variable ? Tech-Mahindra3
I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run? Wipro2
wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence? Target3
what is difference between folders and category ? Tech-Mahindra4
What is Complex Reports? TCS2
 
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