Interested to Buy Any Domain ? << Click Here >> for more details...
when we go for snow flake schema rather than star schema ?
- 5 Answers
- 11959 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 can i add two different reports in the same document?
What are the steps to do to use alerts in bo?
what are the roles and responsibilities of BO Administrator ?
1 Answers OCS Infotech, TCS, Wipro,
Explain how to schedule the report in b.o?
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?
Explain about a tricky situation for which you found a very simple solution?
GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?
in universe perameter u dont give the option multiple contexts ,what is the impact in report level
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.
how to create reports on screech?
can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.
What is aggregate table and aggregate fact table ... Any examples of both?
Teradata 
