What is Snow Flake Schema design in database?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the different types of data warehousing?

519


What is the difference between datawarehouse and bi?

524


What is crass reference table?

595


Define Data Warehousing?

741


How do you define data block size?

589






Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

587


What is the main difference between inmon and kimball philosophies of data warehousing?

663


Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

517


What should I have in mind when building olap solution from scratch?

539


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

533


What is an er diagram?

638


Is there any difference in testing database and data ware housing?

2276


How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

497


Explain me what is vldb?

524


What are data modeling and data mining? Where it will be used?

548