Answer Detail: RE: can you convert a snowflake schema in to star schema?

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Print |

Question: can you convert a snowflake schema in to star schema?

December 12, 2007 03:00:28	#3
VAMSIKRISHNACH	Member Since: December 2007 Total Comments: 7
RE: can you convert a snowflake schema in to star schema?
Snow flake schema = star schema with some dimensions normalised eg : time Just keep the all time denormalised info in single table instead of maintaing multiple normalised tables that gives the best star schema