Interested to Buy Any Domain ? << Click Here >> for more details...
What is Snow Flake Schema design in database?
- 3 Answers
- 8018 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 is real-time datawarehousing?
How to generate the cubes in framework manager?
What are Fact tables and Dimension Tables?
I need a good brd and uc template?
How to generate iqd file from framework manager?
For faster process, what we will do with the universe?
what is the difference between etl tool and olap tools
What are the mapping paramaters and maping variables?
Why facts table is useful in representing the data?
What are aggregate tables and aggregate fact tables?
Explain what are necessary tasks to install reportnet software?
Ist the schema that a data warehouse system can implements.
Teradata 
