Interested to Buy Any Domain ? << Click Here >> for more details...
What is Snow Flake Schema design in database?
- 3 Answers
- 7957 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swamy.l.n
1.IN A STAR SCHEMA IF A DENORMALIZE DIMENTION TABLE SPLITED
INTO ONE OR MORE DIMENTION TABLE RESULTS IN THE
NORMALIZATION OF DIMMENTION TABLE.
2.SINCE THE D-BASE DESIGN LOOKS LIKE A SNOW FLAKE
STRUCTURE.IT IS KNOWN AS SNOW-FLAKE(OR)STAR-FLAKE.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / srinivas
Snow flake schema is a database. it is having centrally
located fact table. and the fact table is surronded by
dimension tables the dimension tables are exploded.
it is a normalized schema.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / azhar
snow flake scheama is one of the type of designs present in
database while the other one is the star schema.It is of
normalized form.
| Is This Answer Correct ? | 0 Yes | 2 No |
What are the steps involved in designing a fact table?
what is parallel query?
What is the data type of the surrogate key?
What are the differences between star and snowflake schema?
How can you implement many relations in star schema model?
Explain what are the different methods of loading dimension tables?
What are different stages of ?Data mining??
What is crass reference table?
Explain what are the various transformation available?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
What is the difference between star and snowflake schemas?
What are the mapping paramaters and maping variables?
Teradata 
