Interested to Buy Any Domain ? << Click Here >> for more details...
when we go for snow flake schema rather than star schema ?
- 5 Answers
- 12166 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 |
HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Can any body tell me,What is the universe testing ? What is the report testing Explain?
How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.
Explain what three things do you consider to be the most important factors for a manager?
wha is the difference b/w merge dimension and combining two different data providers?
What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...
I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?
I want to do on drill calculation? Actually My report is like Continent Amount(Global Currency in dollar) ASIA 200 UK 100 On Drill ASIA Country Amount INDIA 5712(120*47.6) SINGAPORE 128(80 * 1.6) On Drill INDIA State Amount DELHI 3712 CHENNAI 2000
Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.
What are alertors in Business Objects?
Hai, Can anyone tell me 'how to use one dataprovider result as an input to another dataprovider?. In BO6.5 there is an option like "select query result". we can use this option in the filter. but the same thing not available in BO XI webi. if any one face this problem , can you please share with me how to do this? Thanks, Narmatha.
Teradata 
