What is Snow Flake Schema design in database?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between dw and bi?

519


What is analytical or analytic mean?

620


What are components of report studio?

538


What is operational data store (ods)?

571


Explain some of modeling tools available in the market?

524






Can any one explain about core dimension, balanced dimension, and dirty dimension?

640


Explain what are the various reporting tools in the market?

559


What is the difference between power center & power mart?

506


Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

540


What is the purpose of cluster analysis in data warehousing?

565


What is data mart in data warehouse?

537


Why is dimensional normalization not required?

629


What is Discover and Execute in XMLA?

1788


What are situations where snowflake schema is better than star schema when the opposite is true?

563


What are modeling tools available in the market?

563