Interested to Buy Any Domain ? << Click Here >> for more details...
What is Snow Flake Schema design in database?
- 3 Answers
- 8129 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 |
4.Explain Snowflkeschema ?
6 Answers EDS, HCL, IBM, iFlex, TCS,
What is cost benefit analysis (cba)?
What is mean by aggregate aware?
Where we use surrogate key explain with example?
What is ?Data mining??
What is difference between Business Objects and Hyperion Essbase? Please help me
which automation tool is used in data warehouse testing?
Advantages of de normalized data?
Explain dimension table ?
Explain why dimenstion tables are denormalized in nature?
What are data modeling and data mining? Where it will be used?
What are steps we have to follow in designing the userfriendly universe?
Teradata 
