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 session timeout and application timeout?
Explain what is full load & incremental or refresh load?
Explain some of modeling tools available in the market?
What is Analysis Services?
What is a source qualifier?
Can you state some of the innovations throughout history?
Which component has onread method and what it is used for?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What are modeling tools available in the market?
How many project sources we can create in metadata?
what are the types of dimension tables
What are necessary tasks to install reportnet software?