4.Explain Snowflkeschema ?

Answer Posted / sudheer.r

snowflake schema is centrally located fact table .and
surrounded by normalized dimension tables..
in snowflake compare to dimensions and ffact table
dimensions are small.dimensions are more compare to ster
chema .. snow flake shema very dificult to understand ...

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

507


What is the difference between ods and oltp?

574


What are algorithms provided by Microsoft in SQL Server?

1575


What is scd1 , scd2 , scd3?

680


What is the data type of the surrogate key?

540






What is "method/1"?

594


What according to you might be the future of data warehousing?

533


Explain what are the modules in power mart?

573


What is the difference between mapping parameter & mapping variable in data warehousing?

559


Explain what are the advantages data mining over traditional approaches?

685


What is data analytics in simple terms?

555


What do you mean by static and local variable?

529


What is metadata in context of a datawarehouse?

550


Difference between cold fusion 5 and cold fusion mx 6?

589


Explain how are the dimension tables designed?

564