Interested to Buy Any Domain ? << Click Here >> for more details...
when we go for snow flake schema rather than star schema ?
- 5 Answers
- 11749 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / murali
snow flake schema is used for the dim tables contains more fields and the Dim_DB Tables are in the Normalization form.
Draw-back: Slow performance for executing the query.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / babu
whether the schema contains in normalized form and data should be redundancy is required then we go for snow flake schema and the dimension table should split into another child table in this situation we go for snowflake schema rather than star schema.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / smiley
When we have multiple tables for single dimension or when we have multidimensional databaes
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / divya
Snow flake schema is used when there are hierarchies,where
as star schema is used when there is only one level and no
hierachies
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / bo_fan
Star schema : fact table with dimension tables around.
Snow flake schema: fact table with dimension tables around
and the dimension tables again have sub tables to it.
Example: When we have a scenario like student table and
subject details table (which is a sub table of student table)
There we can go for snow flake schema(going more details ie
normalization)
| Is This Answer Correct ? | 1 Yes | 4 No |
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
What happens in BO when a user logs in to Infoview and a rich client like webi?
How do scheduling the report in BO XIR2? can you say what are they steps?
what is the different between link and join ?
I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?
What is meaning of fullpath client in business objects?
1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?
What are the steps to do to use alerts in bo?
REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.
what r the advantages of creating the universe?
HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?
what is casual dimension?
Teradata 
