4.Explain Snowflkeschema ?

Answer Posted / samir kumar sahoo

In snowflake schema the dimension table(denormalized table)
will be further divided into one or more dimentions
(normalized tables) to organize the infomation in a better
structural format.To design snowflake we should first
design star schema design.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the other names given to data warehousing?

658


Explain Association algorithm in Data mining?

1881


What is fact less fact table? Where you have used it in your project?

515


Explain about core dimension, balanced dimension, and dirty dimension?

572


How to create different types of templates?

526






Explain dimension table ?

570


What are modeling tools available in the market?

578


Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

555


Explain degenerate dimension table?

552


Explain me what is vldb?

533


Explain in detail abt measure objects? And what is the use of it? How to create it?

563


Explain what is the extension of file to save template?

522


Is there any rownum object from which we can do this?

535


What is core dimension?

563


How can we load the time dimension?

713