What is Snow Flake Schema design in database?
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 target types on the server?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Explain some of modeling tools available in the market?
What is the difference between star and snowflake schemas?
What is the difference between a W/H and an OLTP application?
Which kind of index is preferred in DWH?
Explain what is difference between query studio and report studio?
What is DTS ?
Disply the dname wise maximum salary
What is a star schema? Why does one design this way?
What are algorithms provided by Microsoft in SQL Server?
Explain swot analysis?